Dear All,
In my work, I have to get month from a datetime value in MySQL. It is like this:
select distinct(Call_log_appt_date_time) from CTMedia_call_log where
month(Call_log_appt_date_time)=4
I am not supposed to write the query as shown above because "month()" is a MySQL function and it creates a protability problem as I am using ADODB. Can anybody kindly help me in solving this issue?
Thanking you,
Indrajit
