Sublime directory Surf the web anonymous Pagerank Monitor


MySQL date (Y-m-d) to something like 2006-June-23... it's possible?

eliezer
Fri 3 November 2006, 12:47 pm GMT +0100
Hi people, I have dates stored in MySQL in Y-m-d format and I want to output them in a common text format. Is that possible?

Here's the 'date' I'm telling you about, I got it from an array that I got from a MySQL query..

$date = $row["fecha"];

I'd be very very grateful if someone can help me.
Thanks any way!

Nikolas
Fri 3 November 2006, 01:21 pm GMT +0100
Can you please explain what you mean by common text format?

eliezer
Fri 3 November 2006, 01:32 pm GMT +0100
Yeah sir, something like: Monday, 1st of October, 2006.

And if I wouldn't be asking too much, I need that on spanish.  :-[
hehe

Nikolas
Fri 3 November 2006, 01:36 pm GMT +0100
First you need to convert the date to timestamp with strtotime() and then you need strftime() to display the date in your language.

eliezer
Fri 3 November 2006, 01:42 pm GMT +0100
Wow man, you're fast.
It would have taken like days to me to know that.
I won't try that for now because it's 6.46am and I havent got any sleep.
Want to see my project, Nikolas? I'm proud of it ;D
Probably you won't understand too much but oh well..
here it is:
http://189.153.91.114/cardio/

PS: on the left menu of the application, look for Serrato

Nikolas
Fri 3 November 2006, 01:45 pm GMT +0100
Yeah right I don't understand nothing, except that it is something about medical..... (this badge with the snakes is from the Ancient Greece, so I can know that....) :)

eliezer
Fri 3 November 2006, 01:48 pm GMT +0100
Haha, well.. it has a lot of functions I just learned when developing it. It has a event scheduler and everything.  8)
Well, I'll get some sleep now man. Take care and have a great day!

Archive for SMF v1.00 by N.P. Valid XHTML 1.0 Transitional