what will be the sure shot solution
-
i have a date problem,
our date format is dd/mm/yyyy
and the sql server in which our website is hosted
there language is us_english and its date format is mm/dd/yyyy
we have a invoice entry page, where users make invoice entries,
we are using Ado
we are using the method
rs.addnew
rs.fields("invoicedt")=dd/mm/yyyy(data here)
but previously it was working
now this date is getting reversed to mm.dd.yyyy
and its causing problems in reports, now iam not sure, all of a sudden what happend.
what if i insert date date as yyyy-mm-dd (SQL Format)
like 2004-14-06
by using command.execute method or something like that, it should not cause any problem in future.
which is the best solution pls suggest.
i have a code pasted in this forum by the topic
"serious date problem" and " one more when u click next 15 page " u will get date problem, there one fellow suggested me some remedies, but they were not very useful..
Thanks in ADVANCE
previously while entering invoice entries
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
-
The date thing is an absolute pain
I have standardised on using yyyy-mm-dd as my date format in my applications and therefore my SQL always has
CONVERT(DateTime,@myParm,120)
See BOL for the options within the CONVERT statement.
-
Using the iso stanbdard format yyyymmdd will always save you headache.
-
OK, have you tried also forcing the connection language settings in your ADO connection string ? this will overide your default language settings.
although i do agree, working in the yyyymmdd seems to be the best way to go.
MVDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply