SQL Data Types Conversions
I'm new to SQL. Anyone have a good example or link of converting from one data type to another.
We are converting from an iSeries (AS400) to SQL-based ERP solution and we are having some difficulty with how to get data from numeric fields to date or "numeric" data types.
Our iSeries ERP solution had two basic data types, Alpha or numeric (with or without decimals).
Now we are confronted with a number of different data type options for numeric or date data in SQL.
Any help would be appreciated.
Thanks
Mike
Software/Hardware used:
Software/Hardware used:
ASKED:
March 24, 2009 2:41 PM
UPDATED:
March 24, 2009 3:55 PM
Answer Wiki:
Don't know what your numeric date field looks like 6, 7, 8 digits
20090321 perhaps??? You didn't say Oracle or SQL/Server or something else.
convert(datetime,'20040508',112)
the SQL convert datetime function changes a character string into a date time. The last parameter
is the format of the incoming string -- 112 is CCYYMMDD.
Hope this helps
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
