List:General Discussion« Previous MessageNext Message »
From:SGreen Date:March 10 2005 1:57pm
Subject:Re: Help massage date import
View as plain text  
Scott Haneda <lists@stripped> wrote on 03/09/2005 08:51:43 PM:

> Mysql 4, I have datetime field set of 0000-00-00 00:00:00
> 
> Sampling of data I need to insert in is as follow:
> 12/26/04 13:35
> 12/25/04 12:41
> 12/25/04 8:53
> 
> How do a massage that to the proper format YYY-MM-DD HH:MM:SS
> 
> thanks
> -- 
> -------------------------------------------------------------
> Scott Haneda                                Tel: 415.898.2602
> <http://www.newgeo.com>                     Fax: 313.557.5052
> <scott@stripped>                          Novato, CA U.S.A.
> 

Scott,

If you are going to continue to work with databases, you need to learn the 
vocabulary of a DBA.

You said:I have datetime field set of 0000-00-00 00:00:00

Possible translations:
A) I have a table with a datetime field where every value in that field is 
'0000-00-00 00:00:00'

B) I have a single record with a datetime field whose value is '0000-00-00 
00:00:00'

C) I have a field declared as a SET with the value of '0000-00-00 
00:00:00'

D) I have a table with a datetime field whose default value is '0000-00-00 
00:00:00'

You said:Sampling of data I need to insert in is as follow

Possible translations:
A) I have some data I need to update my existing records with

B) I have some data I need to add to my table

C) I have several values that I want to cram into a single field

D) I have new data that needs to be added as a new column to the records 
in an existing table

Please try to rephrase your problem using more precise terms. I can see 
one problem already, some TIMESTAMP fields are automatically filled in 
with a value EACH TIME a record is modified by the server (RTFM for 
details). If you want to store date and/or time information in a field and 
you do not want to worry about it being overwritten during the next 
UPDATE, use a DATETIME column.

ALSO!! The methods available to you to change dates from one format to 
another depends ENTIRELY (completely, absolutely) on HOW you are moving 
that data into your MySQL server. Please describe the entire process (as 
you planned it) including the data source and what OS you are using.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Thread
Help massage date importScott Haneda10 Mar
  • Re: Help massage date importSGreen10 Mar