|
-
Mar 24th, 2005, 04:50 AM
#1
Thread Starter
Fanatic Member
[RESOLVED] SQL Date Issue
Im having an issue when inserting a date into my sql server table.
the table's date column is set to smalldatetime
so when i try to insert the date 23/03/2005 into the column, when i look on sql server the field contains 01/01/1900
however if i insert 03/23/2005, when i look on sql server the field contains 23/03/2005
why is this happening..... my regional settings are set to GMT.
Barry
Visual Studio .NET 2008/Visual Studio .NET 2005/Visual Studio .NET 2003
.NET Framework 3.0 2.0 1.1/ASP.Net 3.0 2.0 1.1/Compact Framework 1.0
SQL Server 2005/2000/SQL Server CE 2.0
If you like, rate this post
Compact Framework for Beginners
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|