convert dutch date format to us format sqlserver

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)

convert dutch date format to us format sqlserver

Author

Topic

kajamohideen83
Starting Member

1 Post

Posted - 2007-02-17 : 08:40:47

hi am using a vb application my system regional setting set to dutch format
i am insert a datetime field to sqlserver from vb in dd-mmm-yyyy format to sqlserver
my sqlquery as follows
insert into name values ('kaja','12-mrt-2007')
the above qry change to insert into name values ('kaja','12-mar-2007')
ie.,12-mrt-2008 originally 11 th march 2007 it generate a error erroe converting varchar to datetime
my sqlserver in us language format ,
how to i convert '12-mrt-2008' to '12-mar-2007'
is any function to covert this date,
if any one know please help me

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-17 : 08:43:41

quote:
insert into name values ('kaja','12-mrt-2007')

use universal format

insert into name values ('kaja','20070312')

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources