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 Quote 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(). Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.