Hai,
Hope this will work.
"select * from products where giftprod_entdate='1/1/2000' order by prodid"