Hi all,

I got a column datetime year to fraction(5) in my table. If i want to insert a record thru dbaccess i have to specify all the parameters, for eg.
"2003-09-09 09:09:09.12345", i have to enter year-mm-dd hh:mm:ss fraction. Is there a way where i can only enter date & it will automatically insert the time & fraction. Also how can i insert the same thru front-end utilities. The env vaiable today does it, but we won't be using it. Appreciate your reply.

Regards,

lloyd

here are some options

EXECUTE PROCEDURE myProc(TODAY, param2, param3...)

or

EXECUTE PROCEDURE myProc(CURRENT YEAR TO FRACTION(5), param2, param3...)

or

EXECUTE PROCEDURE myProc(DATE("1/2/2003"), param2, param3...)

rgds,
ghed

Hi Ghed,

Thanks a lot for your feeback.

Regards,

lloyd