Forum Discussion

mbeckham's avatar
mbeckham
Occasional Contributor
4 years ago
Solved

DateTime milliseconds rounding

Hi,  I'm hoping there is someone who may have a solution to my problem. I have a SQL database column ActionDateTime (datetime) with the following value:  The value displayed on the website is...
  • AlexKaras's avatar
    AlexKaras
    4 years ago

    Hi,

     

    Consider .GetHours() and .GetMinutes() methods of aqDateTime object to get just hours and minutes and combine obtained values with the date and format as required.

    Or convert the value obtained from the database to string and get a substring excluding everything after minutes.