[solved]date_format sql in query

[solved]date_format sql in query

El Forum
Guest

09-18-2012, 10:15 AM

[eluser]swgj19[/eluser]
Thanks CroNix, the date is displaying Monday September 2012. It is working.

I learned something new. I knew that I could not just loop through the raw column 'pub_date', I had to have a new function. I did not know that AS formatted_date could be declared in the sql query.

Can you further explain

Quote:because you don’t want the identifiers escaped on that one (that’s why there is a FALSE as the 2nd parameter there)

Messages In This Thread

[solved]date_format sql in query - by El Forum - 09-17-2012, 10:52 PM

[solved]date_format sql in query - by El Forum - 09-18-2012, 12:36 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 12:47 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 09:34 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 09:42 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 09:49 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 10:02 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 10:08 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 10:15 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 10:24 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 10:30 AM

[solved]date_format sql in query - by El Forum - 09-18-2012, 10:34 AM