Date Conversions 2

[chkote]

I have a database which contains "date" data in the format
'20010518'. Is there any way I can convert these to a true date format...e.g. 18/05/2001?
Any suggestions would be appreciated.
Thanks

 

[tlbroadbent]

Create a date column on the table. If the date column is named DateCol and the text column is name TextCol then the following query will store the converted date in DateCol.

Update table1 Set DateCol = DateSerial(Left(TextCol,4),Mid(TextCol,5,2),Right(TextCol,2)) Terry

;-) The single biggest challenge to learning SQL programming is unlearning procedural programming. -Joe Celko

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[chkote]

Thanks Terry, with a couple of mods did the trick beautifully!