arrrr yes thats the catch, us dates that had the middle value XX/thisone/XXXX under 12 can not be changed, so although all the date now appear to be UK dates, there are still dates which are US style as the middle value was less then 12! :(
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
-...
Hi guys, thanks for the input,
I didnt find a solution but just converted the date in to uk using the following. Incase anyone else is stuck on the same thing.
i used
<%
session.lcid = 2057
' connection code here
Set rsUpdate = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT *...
Hey guys thanks for all your input,
Just for other users who may have the same problem, here is the solution i finally used.
<%
session.lcid = 2057
' connection code here
Set rsUpdate = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT * FROM tbl_users"
rsUpdate.CursorType = 2...
hello all,
I have dates in a varchar column in my database which are US and UK (MM/DD/YYYY and DD/MM/YYYY)
Bad news i know, , but we want them all to be UK, however they are all mixed up!
Is it possible for ASP to determine wheather they are US or UK?
help!
Thanks...
Hello all,
I have 3200 entries of user Date of birth (DOB) entries in MM/DD/YYYY as a varcvhar.
i need to change these strings into DD/MM/YYYY, basically swap the numbers in the string around.
Is this possible?
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
- Doh...
Ouch, sorry thank for pointing that out it is supposed to be
id < 3273
user_id is a varchar column! I corrected that but now i am back to my original error of
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
I tihink i will start to...
yes! my first 3200 entries are MMDDYYY i didnt mention this earlier because insert the extra bits on my side
i use
Update tbl_users
Set user_dob = convert(smalldatetime, convert(smalldatetime,user_dob), 101)
where user_id < 3273
i get
Syntax error converting the varchar value 'lla' to a...
thanks for the input guys, but getting a different message now
Server: Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
- Doh
http://www.my-portfolio.me.uk
no, unfortuanatly i still get the same error with
SET DATEFORMAT DMY
Update tbl_users
Set user_dob = CAST(user_dob AS smalldatetime)
Where user_dob is not null
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
- Doh
http://www.my-portfolio.me.uk
Hello all,
i get the following error
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
When i execute
Update tbl_users
Set user_dob = convert(smalldatetime, user_dob, 103)
Where user_dob is not null
I am trying to convert...
Would sql script shall i execute to convert some of the dates that can be determined?
Im still getting to grips sql server capabilities.. maybe something like
isdate(user_DOB(MM))>12 then
Swap the DD and MM ??? but the column is a varchar at the mo...
Hello all,
I have a large database of user which used to use an amercian based server which stored all birth days as 03/21/1998(MM/DD/YYYY) in a VarChar column...
...Later we switched our server and the dates where then been stored as 26/12/1998 (DD/MM/YYYY)...
As you can guess this is a bit...
Hi Billy Ray,
Yes i have changed the code so it posts the URL i want, slightly different but same effects.
Thanks for your input guys(and gals).
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
- Doh
http://www.my-portfolio.me.uk
im getting customer.value is null or not an object?
With my new code
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
- Doh
http://www.my-portfolio.me.uk
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.