get the date from sql server

[Guest]

how to get the date from sql server
in yyyy/mm/dd

 

[OHM \( One Handed Man \)]

select getdate();

 

[Guest]

To format the data in aparticular way use the CASt and/or CONVERT functions

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp