|
|
Posted by Daz on 10/08/06 19:44
Daz wrote:
> 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...
Please excuse my whilst I take my foot out of my mouth. I read MySQL,
and it actually said MsSQL. I would recommend you use a real DMS, if
possible (just my opinion). And maybe try posting in another group more
MsSQL oriented, as it sounds like it it could be a fault with the
database.
My answers were off-topic, but I thought I could help.
Sorry.
Navigation:
[Reply to this message]
|