Απ: Converting varchar to datetime

spaceman — Thu, 01 Nov 2007 21:33:51 GMT

SELECT CONVERT(varchar(30), CAST(STUFF(@myvar, 3, 0, ':') AS DATETIME), 114)

WHERE ISDATE(STUFF(@myvar, 3, 0, ':')) = 1

-- HTH --

Converting varchar to datetime

nikolaosk — Thu, 01 Nov 2007 07:20:30 GMT

με αφορμή, πάλι ερώτηση φίλου, που ήθελε να μετατρέψει μια varchar του τύπου hhmm σε μία datetime, της μορφής 14:30:00. Η Varchar Τιμή είναι hhmm=1430

code snippet follows

declare @myvar varchar(10)
set @myvar = right('0000' + '1430',4)
select  left(@myvar,2) as hour, right(@myvar,2) as minutes, 
convert(varchar(20),dateadd(minute, cast(right(@myvar,2) as int), dateadd(hour, cast(left(@myvar,2) as int), 0 )),8) as finaltime

Πρώτα Βήματα - Βάσεις δεδομένων

Απ: Converting varchar to datetime

Converting varchar to datetime