Quote:
|
Originally Posted by flyboy
Thank you for the link about format masks. You might be interested in these ones:
Can you explain, why you used 'SS.SSSSS'? Instead of the fact it is duplicated, it is also inconsistent (as 02.34.26 PM = 52466 seconds after midnight).
Did you not want to use FF format mask instead? Something like
Code:
SQL> select to_timestamp('17-APR-09 02.34.26.637000000 PM','DD-MON-YY HH12.MI.SS.FF9 PM') from dual;
TO_TIMESTAMP('17-APR-0902.34.26.637000000PM','DD-MON-YYHH12.MI.SS.FF9PM')
---------------------------------------------------------------------------
17-APR-09 02.34.26.637000000 PM
1 row selected.
SQL>
|
Hello,
I donot know why but I posted an email in this thread to epxlain situation ,and now I cannot see that post,did I mispost it?
Anyway problem is that I was querying wrong column instead of one I was supposed to query.Now I can get results with trunc function in
trunc(send_date)=trunc('01-022009')
format as I was used to get.
Sorry for taking your time and making busy.
ps:I didnot create table structure therefore I donot know why "ss.sssss" is used.
Best Regards