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 2005 Forums
 Transact-SQL (2005)
 date

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2010-01-15 : 10:07:03
How is it possible to convert this '2010-01-14T00:00:00+00:00' to a smallddatetime datatype to show 14/1/2010
?
Thanks

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-01-15 : 10:21:40
If you want to show it in a front end, its better you do the formatting there.
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2010-01-15 : 10:38:01
Solved, thank you
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-01-18 : 02:41:13
quote:
Originally posted by arkiboys

Solved, thank you


How?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2010-01-19 : 14:58:49
I solved it in c#
Go to Top of Page
   

- Advertisement -