Compare DateTime in Oracle 8i
I have a table that store datetime(example: StartDate) that store the date and time. Now i have a form in vb6 that search the startdate by searching only date.
example: startdate in table(12/01/2007 11:00:00 AM)
I want to search 12/01/2007.
I mean that it search only date(not include time). How to do that? Thanks.
Re: Compare DateTime in Oracle 8i
You will need to format the datetime on the server to date only and then format the seach as a date using Oracle To_Date function.
Re: Compare DateTime in Oracle 8i
How can I format the datetime on the server to date only? Thanks.
Re: Compare DateTime in Oracle 8i
To_Date(To_String(fieldname,'mm/dd/yyyy'),'mm/dd/yyyy)