View Single Post
Old January 6th, 2011, 09:41 AM
shekhar12 shekhar12 is offline
Registered User
Join Date: Jan 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to get no of days


Could you help me how to get no of days with current date.

I have a table with one column with dateWithTime.

essume that, my table name is xyz, coulumn name is date1.

I need to substract date1 with sysdate like this (sysdate-date1)

Please help me how to write the query.