Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Unanswered: Datetime variable

    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

  2. #2
    Join Date
    Nov 2002
    Posts
    11
    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

  3. #3
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Originally posted by ghed
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •