Change field type in the database: from varchar to date

[mikerh9]

The databases that I use have a lot of data. Using two databases. I'm writing the php code, that will compare Date field and update wrong date in the second database. However, First database uses for date type "varchar(10)" and second database uses "data" type. Is that possible to convert from varchar to date before making comparison?

Thanks

[zone16]

What database are you using?

what you can do is convert on of your fields

eg:
select convert(varchar(10),ze_date_field,105)

will change your date to dd-mm-yyyy format(105)

that works in sybase. test it out in your db.

'njoy,

zone16

[mikerh9]

MySQL 3.2 .. It's not working ..

[zone16]

for mysql try DATE_FORMAT

select date_format(ze_date,'%d-%m-%Y') will give you dd-mm-yyyy

It's probably easier to change your date to varchar and compare varchar...

hope it help,

zone16