Search Results

Right but I need to have this done within the sql statement , in the to_char. Thanks for the post

Ok here is what I have found, the column is date/time data, the EPOC time I receive is 1250909923000. I've found that this is was too many numbers, but when you remove the last 3 "0's" in the string,...

Not sure the last post was handled as it had a link, but here is the cause of the error code from a website

Cause: The user is attempting to either convert a number to a string via TO_CHAR or a...

This is date datatye
Here is a link to what the error code is about
ORA-01481: invalid number format model (http://ora-01481.ora-code.com/)

I'm trying to reread SQL info to get the correct...

Jobrun table does hold run time columns and the endtime column holds the time the job end time.

Gives me this error
ERROR at line 1:
ORA-01481: invalid number format model
When I use the code with date format, Here is my code that is getting errors

#!/usr/bin/sh


sqlplus -S...

That almost got it, at least now I'm in epoc time
I didwhat you posted, and it gave me an error, so I removed the 'MM/DD/YY' from the query and that's how I got the epoc time. So almost there, I may...

Hi All, I'm new to this forum, and appreciate any assistance with my issue.
I have a shell script that logs into an oracle DB and runs a sqlplus query. Everything works great except for the time I...