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)
 ToOADate		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

arkiboys
Flowing Fount of Yak Knowledge

1341 Posts
Posted - 06/29/2012 :  06:29:53  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8515 Posts
Posted - 06/29/2012 :  06:36:40  Show Profile  Visit webfred's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

1341 Posts
Posted - 06/29/2012 :  06:40:38  Show Profile  Reply with Quote
Thanks
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