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 |
|
havejeet
Starting Member
5 Posts |
 Posted - 2009-03-31 : 02:50:24
|
| Hi all,I have data like 20070423142807 and now i want to convert it to datetime like 04/23/2007 14:28:07 (i.e. mm/dd/yyyy hh:mm:ss) - please suggest me earliest.thanksJeetregardsJeet |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-03-31 : 03:02:51
|
| declare @n nvarchar(20)set @n='20070423142807'select cast(stuff(stuff(stuff(@n,9,0,' '),12,0,':'), 15,0,':') as datetime)MadhivananFailing to plan is Planning to fail |
 |
|
|
havejeet
Starting Member
5 Posts |
Posted - 2009-03-31 : 03:31:04
|
| Genius-Buddy, thanks a bunch!JeetregardsJeet |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-03-31 : 03:48:22
|
quote:
Originally posted by havejeet
Genius-Buddy, thanks a bunch!JeetregardsJeet
You are welcome  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
nvarchar to datetime