generate mysql timestamp

[Lars Plessmann]

how can I generate a mysql timstamp value of the current time?

sample:
20040605042505
YYYYMMDDhhmmss

is it only possible by concat year.month.day.hours.minutes.seconds or is
there any final function included in PHP to do that for me?
I didn't find it, yet.
I hope you can give me a hint?

thanks,
Lars

[Tim Van Wassenhove]

In article <40***********************@newsread2.arcor-online.net>, Lars Plessmann wrote:

how can I generate a mysql timstamp value of the current time?

It's in the MySQL manual. Where it should be. Meaby you want to have a
look at the NOW function overthere too.

--
Tim Van Wassenhove <http://home.mysth.be/~timvw/contact.php>

[Lars Plessmann]

Tim Van Wassenhove wrote:

In article <40***********************@newsread2.arcor-online.net>, Lars Plessmann wrote:

how can I generate a mysql timstamp value of the current time?

It's in the MySQL manual. Where it should be. Meaby you want to have a
look at the NOW function overthere too.

No I need it in PHP to store it in an Object variable.
So I don't want to call a SELECT or any other mysqwl based function.

[Tim Van Wassenhove]

In article <40***********************@newsread2.arcor-online.net>, Lars Plessmann wrote:

Tim Van Wassenhove wrote:

In article <40***********************@newsread2.arcor-online.net>, Lars Plessmann wrote:

how can I generate a mysql timstamp value of the current time?

It's in the MySQL manual. Where it should be. Meaby you want to have a
look at the NOW function overthere too.

No I need it in PHP to store it in an Object variable.
So I don't want to call a SELECT or any other mysqwl based function.

I'd use a unix timestamp then. Both PHP and MySQL know how to handle it.

--
Tim Van Wassenhove <http://home.mysth.be/~timvw/contact.php>

[Philipp Kern]

On 2004-06-05, Lars Plessmann <La************@gmx.de> wrote:

is it only possible by concat year.month.day.hours.minutes.seconds or is
there any final function included in PHP to do that for me?
I didn't find it, yet.

The hint would be `date' and `format string'.
date('YmdHis', $timestamp)

But you could also save the timestamp as int(11) in the table.

Bye,
phil
--
Please send replies (not followups) to the address set in Reply-To.
Philipp Kern - PK2186-RIPE - http://www.philkern.de

[Lars Plessmann]

Tim Van Wassenhove wrote:

In article <40***********************@newsread2.arcor-online.net>, Lars Plessmann wrote:

Tim Van Wassenhove wrote:

In article <40***********************@newsread2.arcor-online.net>, Lars Plessmann wrote:
how can I generate a mysql timstamp value of the current time?
It's in the MySQL manual. Where it should be. Meaby you want to have a
look at the NOW function overthere too.

No I need it in PHP to store it in an Object variable.
So I don't want to call a SELECT or any other mysqwl based function.

I'd use a unix timestamp then. Both PHP and MySQL know how to handle it.

My question was if it is possible to generate a timestamp in the mysql
format. I did not ask how to handle it better.
There a several reasons why I have to do it in that way!

Well, do you know a function? Otherwise I will generate it manually.
thanks in advance,
Lars

[Lars Plessmann]

Philipp Kern wrote:

On 2004-06-05, Lars Plessmann <La************@gmx.de> wrote:

is it only possible by concat year.month.day.hours.minutes.seconds or is
there any final function included in PHP to do that for me?
I didn't find it, yet.

The hint would be `date' and `format string'.
date('YmdHis', $timestamp)

But you could also save the timestamp as int(11) in the table.

Bye,
phil

well, okay :)
that was what I was searching for!

thanks, Philipp!