|
|
|
|
H-Desk.com - PC Security matters - Protect your PC privacy
|
|
Access SQL date format problem
|
|
|
| Author |
Message |
manuel
Joined: 23 Aug 2005
Posts: 212
|
 Posted: 05/29/07 - 04:04 Post subject: |
 |
|
| Hello! I am beginner in access SQL, but I am not so bad. I have a problem, so, I need your explanation. In my access I have written date in format dd/mm/yyyy. Everything was just fine until sql statements was build. I got format mm/dd/yyyy. I know that this format is US one and I do not want it. What I should to do? |
|
|
Back to top
|
|
|
|
 |
maxim
Joined: 18 Jan 2006
Posts: 184
|
| Posted: 06/28/07 - 00:23 Post subject: |
|
|
| Well, I have to be true with you: you can not do anything. Your access allows you to enter date in your local format, but for SQL this format is not default, so it converts your date to to correct format (mm/dd/yyyy). This is because on your computer this is default format setting. If you change date settings on your computer to dd/mm/yyyy, then sql will accept it as default one. |
|
|
Back to top
|
|
|
|
|
|
  |
All times are GMT
|
|
|
