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)
 ToOADate

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-06-29 : 06:29:53
Hi,
An existing c# code is using something like:

datetime mydate = '11 april 2009'

mydate.ToOADate which equates to a number.

Question:
1- I need to translate this into SQL.
What is the sql equivalent of ToOADate please?

Thanks

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-06-29 : 06:36:40
maybe russell's answer in this post?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=154121


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2012-06-29 : 06:40:38
Thanks
Go to Top of Page
   

- Advertisement -