Converting String Fields Into Date

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 2000 Forums

SQL Server Development (2000)

Converting String Fields Into Date

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-21 : 06:32:46

Rasha Malek writes "Hello Dear Sir

I Have A problem In SQL Server

My SQL Server DataBase table In In String Format ( It Saves String Formats (NVarCar))

And I Want To Convert It into Date Format To Compare It With Today Date

It`s String Format Is Italian Format : dd-mm-yyyy

Please Send Me The Answer"

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2003-02-21 : 09:45:58

may help..........

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=20630

===========
Paul

uberman
Posting Yak Master

159 Posts

Posted - 2003-02-21 : 10:05:40

SET DATEFORMAT dmy

may also help...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources