Recent content by hpadwal

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...

hmmm thanks guys, much appreciated :( _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ - Doh http://www.my-portfolio.me.uk

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...

Amazing, really handy script :) oldStr '03/24/2006' newStr = mid(oldStr,4,2) & "/" & left(oldStr,2) & "/" & right(oldStr,4) :) _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ - Doh http://www.my-portfolio.me.uk

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...

that error appears wen i use vongrunt's example _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ - Doh http://www.my-portfolio.me.uk

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

yep, user_dob is varchar at the moment _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ - 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...

I have 10500 records and about 2000 will hhave US style dates! _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ - Doh http://www.my-portfolio.me.uk