Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: SQL 2005 database & date formats...
Started 1 month, 3 weeks ago by leeshadmi
Hi, My dev computer set to be as USA date format ex: MM/DD/YYYY. All works for me and for other coputer in this format but when i try my application + it's database on other computer that have the UK format ex: DD/MM/YYYY it not working and i cant save my data to the datbase. My code not related to this format or other so i guess my problems is with my database fields settings. What...
Site: CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile
Forum: Database  Database - forum profile
Total authors: 3 authors
Total thread posts: 6 posts
Thread activity: no new posts during last week
Domain info for: codeguru.com

Other posts in this thread:

VictorN replied 1 month, 3 weeks ago
The "standard" (or locale independent) SQL format for date/time is: 'YYYY-mm-dd HH:MM:SS'
Size: 107 bytes
Customize:  Customize "<b>Reply 1</b>: SQL 2005 database & date formats... :: Database :: CodeGuru Forums - A Developer.com Community for C+..."

leeshadmi replied 1 month, 3 weeks ago
How can i set it i use SQL 2005 Express Edition? My database is attached.
Size: 81 bytes
Customize:  Customize "<b>Reply 2</b>: SQL 2005 database & date formats... :: Database :: CodeGuru Forums - A Developer.com Community for C+..."

VictorN replied 1 month, 3 weeks ago
UPDATE MyTable SET CurrentTime_for_Zone_UTC_plus_3 = '2009-10-29 09:27:50'
Size: 74 bytes
Customize:  Customize "<b>Reply 3</b>: SQL 2005 database & date formats... :: Database :: CodeGuru Forums - A Developer.com Community for C+..."

leeshadmi replied 1 month, 3 weeks ago
ok ,thanks i will try this
Size: 26 bytes
Customize:  Customize "<b>Reply 4</b>: SQL 2005 database & date formats... :: Database :: CodeGuru Forums - A Developer.com Community for C+..."

Alsvha replied 1 month, 3 weeks ago
While the ISO format that VictorN gives always should work, you can also define it in cast/convert functions for when you're not writing it manually. Take a look at this page from msdn: http://msdn.microsoft.com/en-us/library/ms187928.a spx
Size: 355 bytes
Customize:  Customize "<b>Reply 5</b>: SQL 2005 database & date formats... :: Database :: CodeGuru Forums - A Developer.com Community for C+..."

 

Top contributing authors

Name
Posts
leeshadmi
3
user's latest post:
SQL 2005 database & date...
Published (2009-10-29 03:54:00)
ok ,thanks i will try this
VictorN
2
user's latest post:
SQL 2005 database & date...
Published (2009-10-29 03:28:00)
UPDATE MyTable SET CurrentTime_for_Zone_UTC_plus_3 = '2009-10-29 09:27:50'
Alsvha
1
user's latest post:
SQL 2005 database & date...
Published (2009-10-29 06:03:00)
While the ISO format that VictorN gives always should work, you can also define it in cast/convert functions for when you're not writing it manually. Take a look at this page from msdn: http://msdn.microsoft.com/en-us/library/ms187928.aspx

Related threads on "CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions":

How to improve speed when adding new records to SQL...  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile Visual C++ Programming - forum profile How to improve speed when adding new records to SQL database?
How to improve speed when adding new records to SQL database?
Going from a SQL Database table to an xml file  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile Visual Basic .NET - forum profile Going from a SQL Database table to an xml file
Going from a SQL Database table to an xml file
ANN: VistaDB 3.0 world's first managed SQL database for...  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile Announcements, Press Releases, & News - forum profile ANN: VistaDB 3.0 world's first managed SQL database for .NET and CompactFramework
ANN: VistaDB 3.0 world's first managed SQL database for .NET and CompactFramework
How to populate owc spreadsheet control with data from...  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile ASP.NET - forum profile How to populate owc spreadsheet control with data from SQL database
How to populate owc spreadsheet control with data from SQL database
How do we propagate default value setting from an SQL...  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile ADO.NET - forum profile How do we propagate default value setting from an SQL database to a Dataset?
How do we propagate default value setting from an SQL database to a Dataset?
Compare with data in sql database  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile Visual Basic .NET - forum profile Compare with data in sql database
Compare with data in sql database
Web based interface and tying into a SQL database...  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile Java Programming - forum profile Web based interface and tying into a SQL database...
Web based interface and tying into a SQL database...
SQL database replacement  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile Database - forum profile SQL database replacement
SQL database replacement
Openning SQL Database From localhost  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile ASP.NET - forum profile Openning SQL Database From localhost
Openning SQL Database From localhost
C# and sql database  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile C-Sharp Programming - forum profile C# and sql database
C# and sql database

Related threads on other sites:

SQL 2005 Date formats  eggheadcafe community - site profile SQL Server newusers - forum profile SQL 2005 Date formats
SQL 2005 Date formats
Query a Sql Database Date Field  p2p.wrox.com Forums - site profile Access VBA - forum profile Query a Sql Database Date Field
Query a Sql Database Date Field
LANDESK SQL Database Date format  Tek-Tips Forums - site profile Intel: LANDesk - forum profile LANDESK SQL Database Date format
LANDESK SQL Database Date format
ISO SQL Date Format / ISO Date Formats - question to...  Discussions in microsoft.public.sqlserver.programming - site profile microsoft.public.sqlserver.programming - forum profile ISO SQL Date Format / ISO Date Formats - question to --CELKO-- on your continued misuse of the inconsistent date formats in your advice in microsoft.public.sqlserver.programming
ISO SQL Date Format / ISO Date Formats - question to --CELKO-- on your continued misuse of the inconsistent date formats in your advice in microsoft.public.sqlserver.programming
ISO SQL Date Format / ISO Date Formats - question to...  SQL Server Forum - site profile SQL - forum profile ISO SQL Date Format / ISO Date Formats - question to --CELKO-- on your continued misuse of the inconsistent date formats in your advice
ISO SQL Date Format / ISO Date Formats - question to --CELKO-- on your continued misuse of the inconsistent date formats in your advice
Migrating Date from an old Access database, with about...  Twitter / marklbreen - site profile marklbreen - forum profile Migrating Date from an old Access database, with about 50% of the tables and columns no longer used to a new fresh SQL Database 4:18 AM Jul 19th from web
Migrating Date from an old Access database, with about 50% of the tables and columns no longer used to a new fresh SQL Database 4:18 AM Jul 19th from web
How to select an SQL database? # database # sql #...  stackoverflow - Identi.ca - site profile stackoverflow - forum profile How to select an SQL database? # database # sql # evaluation http://beta.stackoverflow.com/questions/29743/how-to-select-an-sql-database about a year ago from web
How to select an SQL database? # database # sql # evaluation http://beta.stackoverflow.com/questions/29743/how-to-select-an-sql-database about a year ago from web
Too may freaking java data formats, util, sql, calendar,...  Twitter / metazippy - site profile metazippy - forum profile Too may freaking java data formats, util, sql, calendar, constants, sql server data formats. sheesh. 2:13 PM Sep 11th from web
Too may freaking java data formats, util, sql, calendar, constants, sql server data formats. sheesh. 2:13 PM Sep 11th from web
SQL DBA - SQL Database Administrator - SQL Server DBA,...  Twitter / CyberCoders - site profile CyberCoders - forum profile SQL DBA - SQL Database Administrator - SQL Server DBA, Orlando, FL. #SQL #job #jobs #careers http://cybercoders.com /?j=HR-SQL-DBA 9:37 AM Nov 12th from API
SQL DBA - SQL Database Administrator - SQL Server DBA, Orlando, FL. #SQL #job #jobs #careers http://cybercoders.com /?j=HR-SQL-DBA 9:37 AM Nov 12th from API
Displaying and updating date formats in SQL (ASP)  Adobe - Forums - site profile Dreamweaver Application Development - forum profile Displaying and updating date formats in SQL (ASP)
Displaying and updating date formats in SQL (ASP)
Thread profile page for "SQL 2005 database & date formats..." on http://www.codeguru.com. This report page is a snippet summary view from a single thread "SQL 2005 database & date formats...", located on the Message Board at http://www.codeguru.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity