Is there any way to use date_format to print regular text? For example, I want the results to look like this:
Tue, Jul 10 at 4:00 PM
I tried:
$sql = "SELECT DATE_FORMAT(date, '%a, %b %d at %l:%i %p') as dt from blahblah";
The result I get is:
Tue, Jul 10 Tuet 4:00 PM
Looks like the 'a' in 'at' is getting interpreted as '%a'.
Thanks
Tue, Jul 10 at 4:00 PM
I tried:
$sql = "SELECT DATE_FORMAT(date, '%a, %b %d at %l:%i %p') as dt from blahblah";
The result I get is:
Tue, Jul 10 Tuet 4:00 PM
Looks like the 'a' in 'at' is getting interpreted as '%a'.
Thanks