[EMAIL PROTECTED] wrote:
I have a field that has the date in the format 22\01\66
I want to change it in SQL to 22/01/66 there are about 500 records
Is there an SQL query I can use to do this?
Ummm... are you storing your data in the database as a string???
If its in as a date, then you don't need to change it. DateFormat(yourDate,"dd/mm/yy") is what you are really after.
If you are storing the date as a string, consider yourself slapped silly!
Stephen
-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
