Re: Extracting DATE from a TIMESTAMP field

2003-06-06 Thread Paul DuBois
At 17:28 -0400 6/6/03, Alex Pilson wrote: At 4:22 PM -0500 6/6/03, Paul DuBois wrote: At 17:17 -0400 6/6/03, Alex Pilson wrote: I have an old table that has about 2000 records and hasn't been modified. I realized it was missing a create_date. Do anyone know or have any slick SQL code to extract o

Re: Extracting DATE from a TIMESTAMP field

2003-06-06 Thread Alex Pilson
At 4:22 PM -0500 6/6/03, Paul DuBois wrote: At 17:17 -0400 6/6/03, Alex Pilson wrote: I have an old table that has about 2000 records and hasn't been modified. I realized it was missing a create_date. Do anyone know or have any slick SQL code to extract out the date from the timestamp field and

Re: Extracting DATE from a TIMESTAMP field

2003-06-06 Thread Paul DuBois
At 17:17 -0400 6/6/03, Alex Pilson wrote: I have an old table that has about 2000 records and hasn't been modified. I realized it was missing a create_date. Do anyone know or have any slick SQL code to extract out the date from the timestamp field and update and insert the date into the create_d

Extracting DATE from a TIMESTAMP field

2003-06-06 Thread Alex Pilson
I have an old table that has about 2000 records and hasn't been modified. I realized it was missing a create_date. Do anyone know or have any slick SQL code to extract out the date from the timestamp field and update and insert the date into the create_date field? Thanks! -- <--