Hello.
I'm writing a script in Perl and dealing with some times that have been stored as integers in a MYSQL database. The times are stored in 24-hour format ( example: 233000 ). This is the first time I've dealt with this date format and need help converting it to display as 11:30 PM. I've googled like crazy and still can't figure it out.
Second problem is that I need to also add a duration to this time to determine the end time. The duration is stored as minutes, so I need to add the duration to the original time and also display that result.
Any help is greatly appreciated.
I'm writing a script in Perl and dealing with some times that have been stored as integers in a MYSQL database. The times are stored in 24-hour format ( example: 233000 ). This is the first time I've dealt with this date format and need help converting it to display as 11:30 PM. I've googled like crazy and still can't figure it out.
Second problem is that I need to also add a duration to this time to determine the end time. The duration is stored as minutes, so I need to add the duration to the original time and also display that result.
Any help is greatly appreciated.