Set variable datetime_format

[ofcalcul]

I have to set the datetime_format variable from "" to "%Y%m%d%H%r%s".
My MySQL server's version is 4.1.14.
I tried to put
setvariable = datetime_format=%Y%m%d%H%r%s in the my cnf or my.ini file and it doesn't work.
Do you have any suggestions?

Thank you,
Cristian

 

[sleipnir214]

In the MySQL online manual, the system variable datetime_format is described as "This variable is not implemented" for all versions.




Want the best answers? Ask the best questions! TANSTAAFL!

 

[ofcalcul]

On my first mysql server, when I get a date, I get something like '20060711184031'.
On this one I get "2006-07-11 18:40:31".
I need to make the second one have the format like the first one.
One difference i found between the server was that the first one didn't have datetime_format at all and the second one had the datetime_format like the date it gets.

 

[ofcalcul]

I have to specify that my field's format is timestamp!

 

[sleipnir214]

Why not then instead use a column type of timestamp?



Want the best answers? Ask the best questions! TANSTAAFL!

 

[sleipnir214]

Are the versions of the two MySQL servers the same?



Want the best answers? Ask the best questions! TANSTAAFL!

 

[ofcalcul]

My column's type is TIMESTAMP. The versions are not the same, suddenly.