Help for this page

Select Code to Download


  1. or download this
    user[29]~/bin>mysql-date-fixer next tuesday
2003-04-29 01:06:55
...
2021-01-01 00:00:00
user[31]~/bin>mysql-date-fixer 982321156
2001-02-16 03:59:16
  2. or download this
    # script name mysql-date-fixer
# NB: Date::Manip is great but it is slow, and this is fun code
...

# a mySQL format, YYYY-MM-DD HH:MM:SS
print UnixDate( $date,"%Y-%m-%d %H:%M:%S"), "\n";