Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   SQL to get date from datetime field (http://www.go4expert.com/forums/sql-date-datetime-field-t20653/)

Saloni Upadhyay 13Jan2010 10:08

SQL to get date from datetime field
 
select convert(varchar,Datecolumn,101)
where
101 ->mm/dd/yyyy
108 ->hh:mm:ss
103 ->dd/mm/yyyy

Function for getting current date in sql --> getdate()

SpOonWiZaRd 28Jan2010 14:05

Re: SQL to get date from datetime field
 
Welcome to G4E, is that a question?

shabbir 28Jan2010 18:30

Re: SQL to get date from datetime field
 
Moved to DB forum


All times are GMT +5.5. The time now is 09:40.