Ho Riaan,

try this one...

select * from mvs_store_all_d ata_time_change
where convert(char,mv s_creation_date ,102) = convert(char,ge tdate()-1,102)

regards,
Pankaj Bhatnagar...