Date Question

[jangoux]

Hi,

I am writing some php/mysql stuff that requires date in dd.mm.yyyy format, but mysql only works with yyyy.mm.dd format, right ? Searching the forum, i found a link to a page with some mysql functions to use with date, like the get_format() which converts (or gets) the format to what i need. The problem is that i don't have a clue how to use them so they can appear like results of my query. Any help ?

Also, how should i compare a given date inserted on the Db with the current date, so the query will only give me the dates starting from today. Can i do something like select date.table where (date >= current_date())....etc ?

Thanks,
Ivan

[LordShryku]

You should convert your dates to the mysql format to store them

$date = date("Y-m-d",strtotime($date_to_submit));

This method usually works. It should also work to convert the date to the format you want to display when pulling it. Though, there are also a ton of MySQL date/time functions you could use as well.

[jangoux]

Thanks for replying, but this was not exactly what i am having trouble. I am able do store the date on the Db by using 3 different text boxes like this :

[13] day [08] month [2004] year

the '[]' being the textboxes and the value inside it, the value that would be posted to the php script to process. Later i would get the date together by using a '.', like this :

assign the $year , $month and $day variables to the posted values using the $http_Vars_post or whatever...and ...

$fulldate = ("$year"."-"."$month"."="."day") ;

Up to this point, it works, but to retrieve the data on another format is where the problem lies. Should i use a special function or there's a solution inside php ?