convert char into datetime
-
Hello friends , i need your help, i got a problem to try convert a data varchar into datetime, well i need to convert a field of a table which is formatted in 'ddmmyyy'
for example
SELECT convert(datetime,'30122006',105)
and i got the next error
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
if the datas of field would be separated by a '-' for example '30-12-2006' I have not the problem the query is executed successful but the datas have not the separator sign, i am think to aggregate it , do you know another idea to solve my problem???
Thanks for read me and excuse me my bad english Cheers
-
When trying to convert the character value '30122006', sql is expecting the value to represented in the format yyyymmdd. I tried your sample and got the same error. adding the '-' allowed me to properly convert the date, as did reformating the string to yyyymmdd format.
You may need to reformat your data before doing the conversion.
-
This works. But be careful in your format as Lynn stated.
SELECT convert(datetime,'20061230',105)
-
yes, that seems the only solution, ok i will resign myself to reformate my data
Thank for read me friend
-
SELECT CONVERT(DATETIME,STUFF(STUFF('30122006', 3, 0, '-'), 6, 0, '-'), 105)
Regards,
gova -
Thanks i will try it
-
gova, so that's why i had trouble using STUFF when I was trying to come up with a conversion solution. Thanks!
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply