Help - Search mySQL post on a date field
Posted: Fri May 14, 2010 11:05 am
Hi all,
When adding in new posts into a mysql table i would like to later on be able to search on posts that was added in the last year or month. Can someone advise the best way to store the dates in mysql? field type and date format? If i use date field instead of varchar the dates are in US format and i want them in UK format. also i am not sure if we can search on them if they are in the format of 14/05/2010.
Hope someone can advise me on best practice.
When adding in new posts into a mysql table i would like to later on be able to search on posts that was added in the last year or month. Can someone advise the best way to store the dates in mysql? field type and date format? If i use date field instead of varchar the dates are in US format and i want them in UK format. also i am not sure if we can search on them if they are in the format of 14/05/2010.
Hope someone can advise me on best practice.