Dear All,
First of all, I would like to thank to Josh and Peter Brawley for their kind
help on previous issue.
Here is another Issue:
There are many tables that have timestamp field with 8 char (mmdd). I use
this format all over our website and to create various reports.
Dear All,
First of all, I would like to thank to Josh and Peter Brawley for their kind
help on previous issue.
Here is another Issue:
There are many tables that have timestamp field with 8 char (mmdd). I use
this format all over our website and to create various reports.
Sure is...
SELECT DATE_FORMAT(dateField,'%Y%m%d') as dateField
Take a look at:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
-Josh
--- Yesmin Patwary [EMAIL PROTECTED] wrote:
Dear All,
First of all, I would like to thank to Josh and
Peter Brawley for their kind
Alternatively, you might be able to re-render times and dates in their
condensed format by auto-converting them to a numeric value. Try adding
zero to your date columns in your select clauses. Once condensed, your
substring code should begin working as before.
SELECT datecol +0 as datecol