SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to validate the timestamp in sql

User349693Sep 26 2012 — edited Sep 26 2012

Hi,

I need to check whether the date column is having timestamp or not. Please give me the query to validate it.

Eg
row1 readtime
1 1/28/2012 4:00:00 PM
2 1/16/2012

I need to vaidate and find the record which is not having the timestamp. Please help me in finding the query for this.
If i use the to_char the value for the date which is not having the time is shown like this '16/01/2012 12:00:00 AM'.
So kindly help me in finding the query for this.

Thanks,
Suresh P

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2012

Added on Sep 26 2012

4 comments

4,212 views