|
|
Posted by Daz on 10/08/06 19:25
iulian.ilea wrote:
> Hello,
>
> I store a date ( format mm/dd/yyyy ) on MsSQL in a datetime field. In
> DB is stored correctly, same format, but when I retrieve it I get
> dd/mm/yyyy. You have any ideea why this is happening?
I would suggest having a look at the date through CLI. The interface
you may be using could be possibly changing the format of the output?
Here's what I get:
mysql> CREATE TABLE test2 (`date` date);
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO test2 SET date='2006-02-01';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT * FROM test2 WHERE 1;
+------------+
| date |
+------------+
| 2006-02-01 |
+------------+
Query OK, 0 rows affected (0.00 sec)
Navigation:
[Reply to this message]
|