Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

current_timestamp

Installation and configuration iussues

Moderators: macek, egami, gesf

current_timestamp

Postby jakeharlan » Thu Apr 14, 2005 1:38 pm

My host just upgraded to MySql version 3.23.59. This is the version I use on my local (test) machine.

There are two issues with the host's upgrade.

The first is the use of current_timestamp. This function seems to not exist on my local machine. When I try to execute a backup of my production database it fails on all create table statments with a timestamp field due to the current_timestamp command.

The second is the timestamp format. Prior to the host's upgrade the timestamp format was yyyymmddhhmmss.
Now the format is yyyy-mm-dd hh:mm:ss. How do I change my local MySql configuration so all timestamps are formatted as yyyy-mm-dd hh:mm:ss?

Any help on these two issues are greatly appreciated.
jakeharlan
New php-forum User
New php-forum User
 
Posts: 8
Joined: Thu Apr 14, 2005 6:13 am

Return to MySQL Installation

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron