|
|
Posted by Daz on 10/08/06 19:30
Daz wrote:
> 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)
Ugh... Only there were rows affected... I just copied the same one
three times...
Navigation:
[Reply to this message]
|