SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Convert string to datetime
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

cms9651
Starting Member

28 Posts

Posted - 02/12/2013 :  11:04:35  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 02/12/2013 :  11:09:34  Show Profile  Reply with Quote
CONVERT(DATETIME,'31/12/2012 16:30',103)
Go to Top of Page

cms9651
Starting Member

28 Posts

Posted - 02/12/2013 :  14:06:55  Show Profile  Reply with Quote
thanks a lot!
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 02/12/2013 :  15:49:53  Show Profile  Reply with Quote
You are very welcome - glad to help.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000