I have imported a dbf table into mssql in a char format 19720628.


How can I convert nvarchar to datetime?

Hi,

Does 19720628 means 1972-06-28 as a date or is it a number?

--
Danijel Novak
MCP+I, MCSA, MCSE, MCDBA, MCT


"Devibez" <Devibez (AT) discussions (DOT) microsoft.com> wrote

Hi,

Yes! This is a date in a nvarchar data type format.

"Danijel Novak" wrote:

DECLARE @str varchar(10)

SET @str = '19720628'

SELECT CONVERT(datetime, @str, 101)

Thanks!

How can I convert all the rows in a column using the method?


"GlennThomas5" wrote:

You can do an update:

UPDATE table
SET <datefield> = CONVERT(datetime, <datefield>, 101)

"Devibez" wrote:

Thank You!


For some reason when I try to run the upadate I receive the following error
message.

Do you you know why?


"Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type datetime.
The statement has been terminated."


Thanks Again!


"DLS" wrote:

you should do a search so see if there are dates that are not in the
proper format. it sounds like there is a numeric value its trying to
convert that is out of sql's date range. you can use ISDATE to see
what values return 0 and those values are out of range.