Thanks a lot for your help it worked. --- Pete <cgrp@xxxxxxxxxxxx> wrote: > In message <fg869k+sfsp@xxxxxxxxxxx>, Sudhakar > <finals27@xxxxxxxxx> > writes > >My requirement is to run a select query to retrieve > a particular > >column on a specific date ex= "SELECT columnname > from tablename > >where columnname='$dt'"; > > > >MY QUESTION IS = without editing the value of the > date and the value > >of the date field being 2007-10-30 08:02:40, how > can i use a select > >query which would ignore 08:02:40 and consider > 2007-10-30 ONLY. > > Assuming that $dt contains "2007-10-30", then > "SELECT columnname FROM tablename WHERE columnname > LIKE "$dt%"; > > > -- > Pete Clark > > Sunny Andalucia > http://hotcosta.com/Andalucia.Spain > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
