I am running SQL Server 2000. I have a field which comes in as a string of numbers representing a date. For example:
122506
is christmas of this year.
70406
is the 4th of July.
I need to get this information stored in a DateTime field in the database. I was hoping to write a stored procedure on this but hours of attempts have ended in failure.
I have tried storing the number as both a bigint and a char with equal failure.
Can someone start me on the right path for this?
THANK YOU!
122506
is christmas of this year.
70406
is the 4th of July.
I need to get this information stored in a DateTime field in the database. I was hoping to write a stored procedure on this but hours of attempts have ended in failure.
I have tried storing the number as both a bigint and a char with equal failure.
Can someone start me on the right path for this?
THANK YOU!