Re: how to conver nvarchar with value like(12.23) to time (12:23)
From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 11/09/04
- Next message: dance2die: "RE: Creating an Index for Temporary table returned by Functions"
- Previous message: Louis Davidson: "Re: Proper Index Choice"
- In reply to: Indra Timilsina: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Next in thread: Indra Timilsina: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Reply: Indra Timilsina: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Reply: Indra: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Nov 2004 15:03:04 -0600
Can you please give us a script of some sample data to try out?
-- ---------------------------------------------------------------------------- Louis Davidson - drsql@hotmail.com SQL Server MVP Compass Technology Management - www.compass.net Pro SQL Server 2000 Database Design - http://www.apress.com/book/bookDisplay.html?bID=266 Note: Please reply to the newsgroups only unless you are interested in consulting services. All other replies may be ignored :) "Indra Timilsina" <itimilsina@savannaenergy.com> wrote in message news:OLjzogpxEHA.4004@tk2msftngp13.phx.gbl... > 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: dance2die: "RE: Creating an Index for Temporary table returned by Functions"
- Previous message: Louis Davidson: "Re: Proper Index Choice"
- In reply to: Indra Timilsina: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Next in thread: Indra Timilsina: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Reply: Indra Timilsina: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Reply: Indra: "Re: how to conver nvarchar with value like(12.23) to time (12:23)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
