Re: how to conver nvarchar with value like(12.23) to time (12:23)
From: Indra Timilsina (itimilsina_at_savannaenergy.com)
Date: 11/09/04
- Next message: Mike: "Cartesian product query"
- Previous message: Hugo Kornelis: "Re: xp_sendmail"
- In reply to: David: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Next in thread: Louis Davidson: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Reply: Louis Davidson: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 09 Nov 2004 12:10:27 -0800
Hi David,
I try as you mentioned, but still I am receiving this error.
"Arithmetic overflow error converting expression to data type datetime"
INSERT INTO TourItemsTemp (FromTime, ToTime, TimeCodeID,
TourItemDescription)
select Cast(replace(Col004, '.', ':') as datetime),
replace(Col005,'.',':'), Col007, Col008 FROM UploadTour
where Col001=N'TTL160';
Thanks.
Indra.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Mike: "Cartesian product query"
- Previous message: Hugo Kornelis: "Re: xp_sendmail"
- In reply to: David: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Next in thread: Louis Davidson: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Reply: Louis Davidson: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
