= Sysdate 1

[sammybee77]

Hi all,

I'm trying to do a basic select where date1 = sysdate(dd-mon-yy)! Please can you tell me how this should be phrased?

Many thanks

Sam

 

[Iby]

Hello,
Try this :

date1 = to_date(sysdate,'dd-MM-yy)

 

[lewisp]

Or this:

trunc(date1) = trunc(sysdate)