in reply to Re: Re: Convert date format in database table.
in thread Convert date format in database table.

So you deal with the HH:MM (which would require a split/[:/ ]/, and don't have to parse the CSV of which this date string was stated to be a field.....

cheers

tachyon

s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print

Replies are listed 'Best First'.
Re: Convert date format in database table.
by cLive ;-) (Prior) on Oct 07, 2003 at 06:23 UTC
    Re-reading the question :)

    'CCYY-MM-DD hh:mm:ss' where all zeroes are required

    Ah, OK, let's re-read that so it makes sense - "where leading zeroes are required". LOL.

    Touché

    cLive ;-)

      The very first Christmas 0000-00-00 00:00:00 might be a literal interpretation ;-)

      cheers

      tachyon

      s&&rsenoyhcatreve&&&s&n.+t&"$'$`$\"$\&"&ee&&y&srve&&d&&print