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.