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.
| Author |
Topic |
|
pmotewar
Yak Posting Veteran
62 Posts |
 Posted - 2009-08-03 : 03:33:51
|
| Hi All,i want to convert the following date string into datetime formate'25/07/2008' --- dd/mm/yyyyi want to convert it into datetime format how can i do it.please help me .Pankaj |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-08-03 : 03:36:02
|
use convert() with style 103convert(datetime, '25/07/2008', 103)
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
pmotewar
Yak Posting Veteran
62 Posts |
Posted - 2009-08-03 : 03:39:57
|
Thanks dudequote:
Originally posted by khtan
use convert() with style 103convert(datetime, '25/07/2008', 103)
KH[spoiler]Time is always against us[/spoiler]
Pankaj |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
|
|
|
|
|
How to convert datetime string into datetime forma