formatting time

Results 1 to 2 of 2

Thread: formatting time

  1. #1
    rdt Guest

    Default formatting time

    When I update a recordset, I want to pass the date and time to the database and store them in two seperate fields. In my SQL statement I&#039m using the Date clause to pass back to the database and store the correct date. I&#039ve gotten the date field to display properly, but the time field is displaying the date and time (ex. 07/17/2000 4:35 PM) How do i get it to display (and store for that matter) JUST the time portion?

  2. #2
    Join Date
    Dec 1969

    Default RE: formatting time

    formatdatetime(now(), 3) &#039for 12 hour time<BR>formatdatetime(now(), 4) &#039for 24 hour time

Posting Permissions

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