Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Convert string to datetime

Author  Topic 

cms9651
Starting Member

28 Posts

Posted - 2013-02-12 : 11:04:35
Convert string to datetime

Hello there, hope in your help.

I've this string datetime and I need convert to datetime:
31/12/2012 16:30

Can you help me?
thank you

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-12 : 11:09:34
[code]CONVERT(DATETIME,'31/12/2012 16:30',103)[/code]
Go to Top of Page

cms9651
Starting Member

28 Posts

Posted - 2013-02-12 : 14:06:55
thanks a lot!
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-12 : 15:49:53
You are very welcome - glad to help.
Go to Top of Page
   

- Advertisement -