sql datetime format

I am trying to开发者_JAVA百科 convert a date into this format YYYY-MM-DD hh:mm:ss eg. 2007-01-05 23:00:00. But my SQL leaves the string unchanged, can somebody tell me what I am doing wrong?

select convert(varchar,'23/02/2008 00:00:00',120)

Try SELECT CONVERT(DATETIME, '23/02/2008 00:00:00'). All you're doing is converting a string into a string, which won't change anything.

your data type needs to be DATETIME, eg:

select convert(DATETIME, '23/02/2008 00:00:00', 120)

try this. Works for Transact-SQL.

select convert(datetime,'23/02/2008 00:00:00')

I hope it helps

maybe you're looking to do this:

CONVERT(varchar,'23/02/2008 00:00:00',100) 'yyyy-mm-dd hh:mm:ss'

select format(getdate(),'dd-MM-yyyy hh:mm tt')

Following is the syntax to achieve what you are looking for

SELECT CONVERT(VARCHAR(19), GETDATE(), 120)

To know more about the date formats see the link http://www.sql-server-helper.com/tips/date-formats.aspx