DATE Format

[yashiro]

Hello
i Have a database in SQLserver.
I am using php to connect to it and to retrieve data from that
database.
I have a table with a column (DATATIME)

where i do :
$result = mssql_query("SE LECT date FROM table1") or
die(mssql_error ());

while ($row=mssql_fet ch_array($resul t,MSSQL_NUM)){
echo $row[1];
}

i got the data like :

17/mars/2008 10:54
18/mars/2008 15:34

why the default date format is : DD/MON/YYYY HH:ii:ss
where can i change de that default format?
or how can i change that format?

i have tried :
echo ;date("d.m.y HH:i", strtotime($row[1]))

it showed me 01.01.70

thanks

[Jerry Stuckle]

yashiro wrote:

Hello
i Have a database in SQLserver.
I am using php to connect to it and to retrieve data from that
database.
I have a table with a column (DATATIME)

where i do :
$result = mssql_query("SE LECT date FROM table1") or
die(mssql_error ());

while ($row=mssql_fet ch_array($resul t,MSSQL_NUM)){
echo $row[1];
}

i got the data like :

17/mars/2008 10:54
18/mars/2008 15:34

why the default date format is : DD/MON/YYYY HH:ii:ss
where can i change de that default format?
or how can i change that format?

i have tried :
echo ;date("d.m.y HH:i", strtotime($row[1]))

it showed me 01.01.70

thanks

This is the format MySQL is returning data. I suggest you try a MySQL
newsgroup.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Captain Paralytic]

On 25 Mar, 10:28, yashiro <noum...@yahoo. frwrote:

Hello
i Have a database in SQLserver.
I am using php to connect to it and to retrieve data from that
database.
I have a table with a column (DATATIME)

where i do :
$result = mssql_query("SE LECT date FROM table1") or
die(mssql_error ());

while ($row=mssql_fet ch_array($resul t,MSSQL_NUM)){
echo $row[1];

}

i got the data like :

17/mars/2008 10:54
18/mars/2008 15:34

why the default date format is : DD/MON/YYYY HH:ii:ss
where can i change de that default format?
or how can i change that format?

i have tried :
echo ;date("d.m.y HH:i", strtotime($row[1]))

it showed me 01.01.70

thanks

I doubt if the column is DATATIME, it is more likely DATETIME.
Could you export the table schema and post it?
According to the manual for MySQL 5.0, the system variables to change
the default datetime output format is not yet implemented so I'm very
surprised to see an output like this from a DATETIME field.
You should use the MySQL function DATE_FORMAT() to output the field
value as you want it.

[The Natural Philosopher]

Captain Paralytic wrote:

On 25 Mar, 10:28, yashiro <noum...@yahoo. frwrote:

>Hello
i Have a database in SQLserver.
I am using php to connect to it and to retrieve data from that
database.
I have a table with a column (DATATIME)

where i do :
$result = mssql_query("SE LECT date FROM table1") or
die(mssql_erro r());

while ($row=mssql_fet ch_array($resul t,MSSQL_NUM)){
echo $row[1];

}

i got the data like :

17/mars/2008 10:54
18/mars/2008 15:34

why the default date format is : DD/MON/YYYY HH:ii:ss
where can i change de that default format?
or how can i change that format?

i have tried :
echo ;date("d.m.y HH:i", strtotime($row[1]))

it showed me 01.01.70

thanks

I doubt if the column is DATATIME, it is more likely DATETIME.
Could you export the table schema and post it?
According to the manual for MySQL 5.0, the system variables to change
the default datetime output format is not yet implemented so I'm very
surprised to see an output like this from a DATETIME field.
You should use the MySQL function DATE_FORMAT() to output the field
value as you want it.

That's what I do.

[Richard]

----- Original Message -----
From: "yashiro" <no*****@yahoo. fr>
Newsgroups: comp.lang.php
Sent: Tuesday, March 25, 2008 11:28 AM
Subject: DATE Format

Hello
i Have a database in SQLserver.
I am using php to connect to it and to retrieve data from that
database.
I have a table with a column (DATATIME)

where i do :
$result = mssql_query("SE LECT date FROM table1") or
die(mssql_error ());

while ($row=mssql_fet ch_array($resul t,MSSQL_NUM)){
echo $row[1];
}

i got the data like :

17/mars/2008 10:54
18/mars/2008 15:34

why the default date format is : DD/MON/YYYY HH:ii:ss
where can i change de that default format?
or how can i change that format?

i have tried :
echo ;date("d.m.y HH:i", strtotime($row[1]))

it showed me 01.01.70

thanks

Hi,
I think you should change the date format in SQL server.
It is possible it depends on your locale.

Best to ask in a MS SQL server newsgroup or forum..
Good luck,
Richard

[yashiro]

thank you guys
i solve the problem myself
i just have to change de format like this

SELECT CONVERT(VARCHAR , incident.date_, 120) FROM table1

then i am able to show the data as i want using date
date("d.m.y", strtotime($row[0]))

thanks

[Jerry Stuckle]

Captain Paralytic wrote:

On 25 Mar, 10:28, yashiro <noum...@yahoo. frwrote:

>Hello
i Have a database in SQLserver.
I am using php to connect to it and to retrieve data from that
database.
I have a table with a column (DATATIME)

where i do :
$result = mssql_query("SE LECT date FROM table1") or
die(mssql_erro r());

while ($row=mssql_fet ch_array($resul t,MSSQL_NUM)){
echo $row[1];

}

i got the data like :

17/mars/2008 10:54
18/mars/2008 15:34

why the default date format is : DD/MON/YYYY HH:ii:ss
where can i change de that default format?
or how can i change that format?

i have tried :
echo ;date("d.m.y HH:i", strtotime($row[1]))

it showed me 01.01.70

thanks

I doubt if the column is DATATIME, it is more likely DATETIME.
Could you export the table schema and post it?
According to the manual for MySQL 5.0, the system variables to change
the default datetime output format is not yet implemented so I'm very
surprised to see an output like this from a DATETIME field.
You should use the MySQL function DATE_FORMAT() to output the field
value as you want it.

Except this is SQL Server, not MySQL.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attgl obal.net
=============== ===

[Michael Fesser]

..oO(yashiro)

>thank you guys
i solve the problem myself
i just have to change de format like this

SELECT CONVERT(VARCHAR , incident.date_, 120) FROM table1

then i am able to show the data as i want using date
date("d.m.y" , strtotime($row[0]))

Looks just like an ugly hack. Doesn't your SQL server have its own date
formatting functions?

Micha

[Richard]

"Jerry Stuckle" <js*******@attg lobal.netwrote in message
news:Se******** *************** *******@comcast .com...

yashiro wrote:

>Hello
i Have a database in SQLserver.
I am using php to connect to it and to retrieve data from that
database.
I have a table with a column (DATATIME)

where i do :
$result = mssql_query("SE LECT date FROM table1") or
die(mssql_erro r());

while ($row=mssql_fet ch_array($resul t,MSSQL_NUM)){
echo $row[1];
}

i got the data like :

17/mars/2008 10:54
18/mars/2008 15:34

why the default date format is : DD/MON/YYYY HH:ii:ss
where can i change de that default format?
or how can i change that format?

i have tried :
echo ;date("d.m.y HH:i", strtotime($row[1]))

it showed me 01.01.70

thanks

This is the format MySQL is returning data. I suggest you try a
MySQL newsgroup.

Except this is SQL Server, not MySQL.
R.