Current date and time?

[staffy]

I have been programming on Oracle Databases for a while, so adjusting to MS is my current dilemma.

How do I pull the current date and time from the server via select statement? I know in oracle, it is "select to_char(sysdate,'mm/dd/yyyy hh:mm:ss am') date from dual", but this is an oracle thing. Is there anything similar in MS?

 

[Psychpt]

select getdate()
if you want it in a specified format use
datepart

HTH