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)
 oracle to sql server date conversion

Author  Topic 

rayans1234
Starting Member

7 Posts

Posted - 2008-03-12 : 21:59:57
Hi Gurus,
I need to convert this statement to sql server.
SELECT to_date('24-08-2007 13:11:12','dd-mm-yyyy hh24:mi:ss'),to_date('24-aug-2007 13:11:12','dd-mon-yyyy hh24:mi:ss') from dual

can anyone help please.

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2008-03-12 : 22:15:44
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98943 duplicate post



Poor planning on your part does not constitute an emergency on my part.

Go to Top of Page
   

- Advertisement -