Skip to Main Content
Forums

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!

Add Minutes to Date Time Stamp in Select Query

895550Nov 19 2011 — edited Nov 19 2011
Hi,

I have date in one column and Minutes (240,480,.....etc) in another column.
Below is the date format which i select in select query, now how should i add date column below with Minutes Column.

to_char(Last_update_date,'DD/MM/YYYY HH:MI:SS AM')


Thanks
Pravin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2011
Added on Nov 19 2011
2 comments
4,761 views