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

Hi,

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.