Update SQL Sentece 2

[forostec]

Hello, recently i upload an excel file into a table but i have some problems with a date field where i have this:

02/09/0200

how can i update the table field to this current year?

Thanks for the help.

 

[RickSchummer]

If you have a copy of FoxPro you can open the table and run:

REPLACE ALL DateFldName WITH ;
     CTOD(STR(MONTH(DateFldName)) + "/" + ;
          STR(DAY(DateFldName)) +  "/" + ;
          YEAR(DATE())) ;
   FOR DateFldName = {02/09/0200}

_RAS

http://www.whitelightcomputing.com

VFP MVP

 

[darrellblackhawk]

Or...

UPDATE tablename ;
SET DateFldName = ;
CTOD(STR(MONTH(DateFldName)) + "/" + ;
STR(DAY(DateFldName)) + "/" + ;
YEAR(DATE())) ;
WHERE DateFldName = {02/09/0200}

Darrell

 

[darrellblackhawk]

Oops!

My previous post won't work in Fox 2.x

Sorry...

Darrell