Subject | Importing and parsing data in stored procedure |
---|---|
Author | Rick DeBay |
Post date | 2004-07-26T15:32:19Z |
I have a table that contains dates and times, but they're stored as
varchar in either yyyymmdd, yymmdd, or hhmmss format. I'm importing
them to another table so I can correctly store them as a Date or Time.
Can I do this with a stored procedure? If so, can someone let me know
what I need to do to parse the fields?
Rick DeBay
Senior Software Developer
RxStrategies.net
varchar in either yyyymmdd, yymmdd, or hhmmss format. I'm importing
them to another table so I can correctly store them as a Date or Time.
Can I do this with a stored procedure? If so, can someone let me know
what I need to do to parse the fields?
Rick DeBay
Senior Software Developer
RxStrategies.net