Thanks Richard.
That did the trick. Now to the DB fixing business...
-Will
Richard Lynch [EMAIL PROTECTED] kirjoitti
viestissä:[EMAIL PROTECTED]
On Thu, May 5, 2005 10:42 pm, William Stokes said:
I made a mistake and stored date information to DB as varchar values
(dd.mm.yyy). When I read
On Thu, May 5, 2005 10:42 pm, William Stokes said:
I made a mistake and stored date information to DB as varchar values
(dd.mm.yyy). When I read the DB is it still possible to sort the data by
date with SQL query (ORDER BY date ASC)? Or is it nessessary to have the
date information to be
Hello,
I made a mistake and stored date information to DB as varchar values
(dd.mm.yyy). When I read the DB is it still possible to sort the data by
date with SQL query (ORDER BY date ASC)? Or is it nessessary to have the
date information to be stored as a date in the DB? Will it work or is
William Stokes wrote:
Hello,
I made a mistake and stored date information to DB as varchar values
(dd.mm.yyy). When I read the DB is it still possible to sort the data by
date with SQL query (ORDER BY date ASC)? Or is it nessessary to have the
date information to be stored as a date in the DB?
On Friday 06 May 2005 08:42, William Stokes wrote:
Hello,
I made a mistake and stored date information to DB as varchar values
(dd.mm.yyy). When I read the DB is it still possible to sort the data by
date with SQL query (ORDER BY date ASC)? Or is it nessessary to have the
date information to
OK. I found that out from MySQL manual. I just don't know how to insert the
date formatting function to the query:
I quessI need to put STR_TO_DATE() in to the following SQL query:
SELECT event_id,name,date,time,place,type,info FROM test_table
WHERE (group = '$group') AND (type = 'Game' OR type
On Friday 06 May 2005 11:17, William Stokes wrote:
OK. I found that out from MySQL manual. I just don't know how to insert the
date formatting function to the query:
I quessI need to put STR_TO_DATE() in to the following SQL query:
What about DATE_FORMAT()?
SELECT
William Stokes wrote:
OK. I found that out from MySQL manual. I just don't know how to insert the
date formatting function to the query:
I quessI need to put STR_TO_DATE() in to the following SQL query:
SELECT event_id,name,date,time,place,type,info FROM test_table
WHERE (group = '$group') AND
8 matches
Mail list logo