Date format - correct setting but no change
Posted: Mon Feb 21, 2005 11:20 am
Ok I thought I had sorted out my date format to print results in UK format, the code below is how I did it and I thought it worked fine:
when I enter 20-02-05 into dateoflast contact(uk time format - dd-mm-yy) in my form it gives me :
05/02/20
and when I enter 21-02-05 into datecontactagain (uk time format - dd-mm-yy) it gives me : 05/02/21
the mysql manual explains how to do it and I followed that to the letter plus some advice off this forum but still it remains the same?
Anyone got any advice or can anyone see anything wrong with this?
Code: Select all
DATE_FORMAT(dateoflastcontact, '%d/%m/%y')
AS dateoflastcontact, DATE_FORMAT(datecontactagain, '%d/%m/%y')
AS datecontactagain05/02/20
and when I enter 21-02-05 into datecontactagain (uk time format - dd-mm-yy) it gives me : 05/02/21
the mysql manual explains how to do it and I followed that to the letter plus some advice off this forum but still it remains the same?
Anyone got any advice or can anyone see anything wrong with this?