List:General Discussion« Previous MessageNext Message »
From:Richard Date:December 15 2003 11:41pm
Subject:Re: Getting Records where date is LESS THAN today, AND...
View as plain text  
Okay, that sounds good and all, but how does that help me, since the date is
chosen
from the javascript "calander" in this format: mm/dd/yyyy

So then, when I'm selecting a date of at least todays value, or less in the
database
how would I do it, since it's in mm/dd/yyyy?

Thanks,
Richard


----- Original Message ----- 
From: "Martijn Tonies" <m.tonies@stripped>
To: <mysql@stripped>
Sent: Monday, December 15, 2003 2:47 AM
Subject: Re: Getting Records where date is LESS THAN today, AND...


> >Is there a BETTER way to do this?
>
> Yes, store a DATE instead of seperate day/month/year values.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
>

Thread
Getting Records where date is LESS THAN today, AND...Richard15 Dec
  • Re: Getting Records where date is LESS THAN today, AND...Richard15 Dec
  • Re: Getting Records where date is LESS THAN today, AND...Martijn Tonies15 Dec
  • Re: Getting Records where date is LESS THAN today, AND...Richard16 Dec
  • Re: Getting Records where date is LESS THAN today, AND...Martijn Tonies16 Dec