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
Discuss This Question: