Thread: Date
I have o big problem!
I have a table which has a field by date type.
The date format is mm/dd/yyyy.
When I'm doing this select:
select da from a where da='03-31-2002';
the result is :
03-30-2002
03-30-2002
03-30-2002
I repet: only on '03-31-2002'!
What's going on?
Thanks in advance for any help.
I have a table which has a field by date type.
The date format is mm/dd/yyyy.
When I'm doing this select:
select da from a where da='03-31-2002';
the result is :
03-30-2002
03-30-2002
03-30-2002
I repet: only on '03-31-2002'!
What's going on?
Thanks in advance for any help.
So that I can have more information, please do: SELECT * FROM table LIMIT 50; Please put on extended display (\x) if your table is wider than the screen. Also, do a \d table Thanks, Jason On Wed, 3 Apr 2002, cristi69 wrote: > I have o big problem! > I have a table which has a field by date type. > The date format is mm/dd/yyyy. > When I'm doing this select: > select da from a where da='03-31-2002'; > the result is : > 03-30-2002 > 03-30-2002 > 03-30-2002 > I repet: only on '03-31-2002'! > > What's going on? > > Thanks in advance for any help. > >