August 18, 2010 at 7:29 pm
Hi
I have a excel were the date columns are in the format
of YYYYMMDD and when am loading the data into the database table
were the columns are of datatype datetime ... I do get a conversion error value...because the values in excel are text formatt..
2 nd task... I have a excel were the column values in the excel are in the format of
300.02
314
314.89
314.01
when am loading the data into database tables were the columns are varchar(6) datatype abovevalues in the table are inserting like
300.01
314
314.89
314.00
values are rounded.....
could someone please help me ..how to insert the YYYYMMDD which is in text format into date format in the database table...
How to insert the varchar column which has number values
into the database table of varchar datatype without round of the values...
August 19, 2010 at 3:45 am
Hi,
Show me your initial query that u made to accomplish this task.
August 19, 2010 at 3:50 am
to convert datetime into text, use
convert(char(8),getdate(),112)
this is just a hint which you can further explore and use it in your code.
----------
Ashish
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply