Tiiiiiiiiiiiiime

hi all.

from a DB table, I'd like to SELECT out the date of 3months before.
the command should be

=> select * from MYTBL where time =XXXXXX ;

what whould it like to be at XXXXX ?
I thought that I can use the type of 'today', which is meant to be the
0:00am of the day.
or 'current' or things like this. but how can you make it "0:00am of three
days ago"?

also, if you know about it,
I'd like to know about the difference between 'current' and 'now'.

thanks about that.

hiroko ogawa