getdate() in sybase?

[mav]

hi) <br />
im currently using Sybase as my database and I would like to extract data from yesterday. In SQL the code would be somehow like GETDATE()-1 but it doesn't work with Sybase...i need help( <br />
Thanks a lot)<br />

 

[Maku]

Use datediff

http//infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug643.htm

 

[piperj01]

Your not going to get any dates until you turn off that computer and get out of the house!