Results 1 to 2 of 2

Thread: Times stored as Integers

  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Times stored as Integers

    The table I access has a time value saved as an integer. For example, 6:05 PM (18:05) is saved as 1,805. I need to be able to convert this to the 24hr time of 18:05. I cannot change the table format, only via my SELECT query. Can anyone help me with this?

    I greatly appreciate any insight!
    Rita Brasher

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Convert it to char first then you can add ':' in the string.

Tags for this Thread

Posting Permissions

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