change '2007-05-10' to current date

[bb nicole]

$sql = select bc_id,company_l ogin,from_unixt ime(bc_time) as bc_time,bc_stat us,bc_total_sen t_out,bc_actual _sent_out
from broadcast
where left(from_unixt ime(bc_time),10 )='2007-05-10'
and bc_status in (2,3)
order by bc_time asc

above is my query for a project,
where left(from_unixt ime(bc_time),10 )='2007-05-10'
how to change '2007-05-10' to current date in same format(yyyy-mm-dd) so i no need to change it manually everytime....

thankx...

[pradeep kaltari]

$sql = select bc_id,company_l ogin,from_unixt ime(bc_time) as bc_time,bc_stat us,bc_total_sen t_out,bc_actual _sent_out
from broadcast
where left(from_unixt ime(bc_time),10 )='2007-05-10'
and bc_status in (2,3)
order by bc_time asc

above is my query for a project,
where left(from_unixt ime(bc_time),10 )='2007-05-10'
how to change '2007-05-10' to current date in same format(yyyy-mm-dd) so i no need to change it manually everytime....

thankx...

Hi,

Try this:

where left(from_unixtime(bc_time),10)=DATE_FORMAT(CURRENT_DATE,'%Y-%m-%d')

I guess this is what you are looking for.

Regards,
Pradeep

[bb nicole]

Yes, thats what i want, thanks a lot, Pradeep...... :)

Hi,

Try this:

where left(from_unixtime(bc_time),10)=DATE_FORMAT(CURRENT_DATE,'%Y-%m-%d')

I guess this is what you are looking for.

Regards,
Pradeep