Results 1 to 2 of 2

Thread: Times stored as Integers

  1. 09-03-2010, 01:47 PM #1
    RBrasher
    RBrasher is offline Registered User
    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
    Reply With Quote Reply With Quote
  2. 09-04-2010, 11:12 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Convert it to char first then you can add ':' in the string.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules