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

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-04 : 00:41:56
Jan writes "I'm trying to insert a string (eks. 31/12/2002) to the database, where it should be converted to (2000-12-31). How do I convert the string to the right format??"

Nazim
A custom title

1408 Posts

Posted - 2002-02-04 : 00:51:21
you can convert it first into datetime and play with its display format.

Check for Convert function in BooksOnline

--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is
Go to Top of Page
   

- Advertisement -