OraUser
Reputation: 1
Convert military time in varchar format to standard time
I am working with a table that stores times in military format as varchar(6). I need to display and calculate durations.
How can I show for example 1015 as 10:15 and calculate 1015 - 30 getting 09:45 ?
I didn't find any conversion functions yet.
Thanks in advance.
Conversion functions and to_date.
Upvotes: 0
Views: 49
Answers (0)
Related Questions
- Conversion failed when converting date and/or time from character string while inserting datetime
- How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
- How to convert DateTime to VarChar
- Convert INT to VARCHAR SQL
- Convert Varchar to ANY time format
- SQL Convert Military time to Time
- How to subtract two varchar columns that contain time value as input
- Convert varchar string data to time format in mysql
- Convert Varchar Column to Datetime format - SQL Server