mdemetri2 Posted January 25, 2012 Share Posted January 25, 2012 Hi Have a database field(varchar) that is used to hold date / time in the following format: dd/mm/yyy : hh:mm Can someone recommend what function to use to bring results back based on the particular month? So...... Is it possible to use something like date_format or str_to_date function to specifically bring back results only where the month = ‘01’ i.e. januaray? Thanks in advance. mdemetri2 Link to comment https://forums.phpfreaks.com/topic/255778-help-with-date-time-stored-as-string/ Share on other sites More sharing options...
fenway Posted January 25, 2012 Share Posted January 25, 2012 STR_TO_DATE(). Link to comment https://forums.phpfreaks.com/topic/255778-help-with-date-time-stored-as-string/#findComment-1311190 Share on other sites More sharing options...
mdemetri2 Posted January 25, 2012 Author Share Posted January 25, 2012 great, thanks, used that function, and works a treat. Link to comment https://forums.phpfreaks.com/topic/255778-help-with-date-time-stored-as-string/#findComment-1311241 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.