-
user_jobs column NEXT_SEC
currently querying this col looks like this:
SQL> select next_sec from user_jobs;
NEXT_SEC
--------
19:34:03
could someone tell me how to convert this column from 24hour clock to 12hour clock time. So that I see this reported as 7:34:03 PM ??
thanks
carl
-
Hope this is wht u expect
select to_char(next_sec, hh:mi:ss) from user_jobs;
Cheers!
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|