SQL Date help

Hi,

I am a newbie to SQL and postgresql too.
please guide me in the following...


1.How i can create date while i am inserting into the table ,in which the
field is date data type.(date should not be a current date and its should be
created
as in java date(int,int,int)

2. How i can compare the date field.
For example ,
how i can get the all the records between to two dates

please help in this regards

i thank you
regards
waheed




_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com