Day names from the base

[jonsof]

i have a date field in my database and i wanna to pull out that date with the name of each day in order to manipulate the exported string.

Is this practicable?

[jpmoriarty]

i find it easiest to store any date in Mysql as a unix timestamp (from php: date("U").

Then it's really east to get what you want from it:

$date = date("U");
echo "The day is ".date("l", $date);
echo "In three days time it will be ".date("l F Y",($date + (60*60*24*3));

etc etc

[jonsof]

Through SQL statement?