-
Problem with dd/mm/yy date convention and ASP-db/MS-Access ???
I have trouble inserting dd/mm/yy dates into ASP-db and MS-Access.
When I try to add a record to my (local) MS-Access database using SQL
inserts (I try to insert the 11th, 12th and 13th of December):
INSERT INTO test (test_date) VALUES (#11/12/98#); >>> inserts "12/11/98"
>>> This is arse-about
INSERT INTO test (test_date) VALUES (#12/12/98#); >>> inserts "12/12/98"
>>> can't go wrong here
INSERT INTO test (test_date) VALUES (#13/12/98#); >>> inserts "13/12/98"
>>> "correct", but inconsistent with first case
Is there a solution in ASP-db???
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
|
|