Getting date (timestamp) as time value?

[Sonnich]

Hi

I'd like to read out a date from the a DB, but as time var. By default
I seem to get it as a string.

E.g.

while(odbc_fetch_row($result))
{
$tt= odbc_result($result,2);
echo date("d.m.Y", $tt).", ".odbc_result($result,6) . " <br>";

S

[Kimmo Laine]

"Sonnich" <so************@elektrobit.comwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...

Hi

I'd like to read out a date from the a DB, but as time var. By default
I seem to get it as a string.

E.g.

while(odbc_fetch_row($result))
{
$tt= odbc_result($result,2);
echo date("d.m.Y", $tt).", ".odbc_result($result,6) . " <br>";

What kind of a string it is? If it's just a regular Y-m-d string, then the
easiest would be first converting it to unix timestamp and then passing that
to date:
date("d.m.Y", strtotime($tt));

strtotime parses the formatted date string and converts it to integer.

--
"Ohjelmoija on organismi joka muuttaa kofeiinia koodiksi" - lpk
http://outolempi.net/ahdistus/ - Satunnaisesti päivittyvä nettisarjis
sp**@outolempi.net | rot13(xv***@bhgbyrzcv.arg)

[Sonnich]

Kimmo Laine wrote:

"Sonnich" <so************@elektrobit.comwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...

I'd like to read out a date from the a DB, but as time var. By default
I seem to get it as a string.

E.g.
while(odbc_fetch_row($result))
{
$tt= odbc_result($result,2);
echo date("d.m.Y", $tt).", ".odbc_result($result,6) . " <br>";

What kind of a string it is? If it's just a regular Y-m-d string, then the
easiest would be first converting it to unix timestamp and then passing that
to date:
date("d.m.Y", strtotime($tt));

strtotime parses the formatted date string and converts it to integer.

Server default format, I guess....
2006-12-05 00:00:00

[Kimmo Laine]

"Sonnich" <so************@elektrobit.comwrote in message
news:11*********************@16g2000cwy.googlegrou ps.com...

>
Kimmo Laine wrote:

>"Sonnich" <so************@elektrobit.comwrote in message
news:11**********************@f1g2000cwa.googlegr oups.com...

I'd like to read out a date from the a DB, but as time var. By default
I seem to get it as a string.

E.g.
while(odbc_fetch_row($result))
{
$tt= odbc_result($result,2);
echo date("d.m.Y", $tt).", ".odbc_result($result,6) . " <br>";

What kind of a string it is? If it's just a regular Y-m-d string, then
the
easiest would be first converting it to unix timestamp and then passing
that
to date:
date("d.m.Y", strtotime($tt));

strtotime parses the formatted date string and converts it to integer.

Server default format, I guess....
2006-12-05 00:00:00

Then strtotime is your friend. Just pass the timestring the server gives to
strtotime and use the timestamp it returns.
--
"Ohjelmoija on organismi joka muuttaa kofeiinia koodiksi" - lpk
http://outolempi.net/ahdistus/ - Satunnaisesti päivittyvä nettisarjis
sp**@outolempi.net | rot13(xv***@bhgbyrzcv.arg)

[Sonnich]

Kimmo Laine wrote:

"Sonnich" <so************@elektrobit.comwrote in message
news:11*********************@16g2000cwy.googlegrou ps.com...

Kimmo Laine wrote:

"Sonnich" <so************@elektrobit.comwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...
I'd like to read out a date from the a DB, but as time var. By default
I seem to get it as a string.

E.g.
while(odbc_fetch_row($result))
{
$tt= odbc_result($result,2);
echo date("d.m.Y", $tt).", ".odbc_result($result,6) . " <br>";
What kind of a string it is? If it's just a regular Y-m-d string, then
the
easiest would be first converting it to unix timestamp and then passing
that
to date:
date("d.m.Y", strtotime($tt));

strtotime parses the formatted date string and converts it to integer.

Server default format, I guess....
2006-12-05 00:00:00

Then strtotime is your friend. Just pass the timestring the server gives to
strtotime and use the timestamp it returns.

jup, but I'd also like to check whether <null... I found a way though.