Syntax for to_date function using sysdate

[kramerd1506]

Hello all,

I need the syntax for to_date(sysdate at 9:00am). Nothing I try seems to work. Thank you in advance!

 

[jbenson001]

Are you referring to GetDate()?

 

[mrdenny]

to_date is an oracle function. If your working in Oracle you'll want to repost in the Oracle forum. If your working in MS SQL you'll be using getdate().

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[kramerd1506]

No, this is for Oracle. 9i I think. I'm looking for the syntax using the to_date() function. Thanks!

 

[kramerd1506]

Ohhh, my bad. Thanks guys, I'll post in Oracle.