Datetime selection help

[Frenchfry]

Hello again,

I have a field thats is datetime within me proc.
The Start and End Dates reside at the top of the proc.

I need help changing the datetime to date allow me to do me selection.

Thanks in Advance.

 

[LKBrwnDBA]

Perhaps you could use the TO_CHAR() function.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Frenchfry]

Thanks
t1.close_time between to_date(dt1,'dd/mm/yy hh24:mi:ss') and to_date(dt2,'dd/mm/yy hh24:mi:ss')

 

[Beilstwh]

trunc(t1.close_time)

will strip out the time element

Bill
Lead Application Developer
New York State, USA