I want to change the DateTime from looking like "2012-05-02 24:12:23.000" to just display the hour and minute like "12:00".
The data is automatically put in the SQL table from a UDP message then the webpage loads the data into a grid.
Asked
Active
Viewed 27 times
0
-
which dbms are you using ? is it microsoft sql server? – eshirvana May 13 '21 at 18:33
-
4Does this answer your question? [How to get only time from date-time C#](https://stackoverflow.com/questions/1026841/how-to-get-only-time-from-date-time-c-sharp) – Timothy G. May 13 '21 at 18:34
-
Yes it is microsoft sql server. – Dmdtrain May 13 '21 at 18:35
-
1@TimothyG. Yes I believe it does. Thank you. – Dmdtrain May 13 '21 at 18:36
1 Answers
0
in sql server :
SELECT CONVERT(VARCHAR(5),getdate(),108)
in postgresql:
select to_char(now() , 'hh:mi')
eshirvana
- 23,227
- 3
- 22
- 38
-
This is not the best way to solve this problem. For instance, what if your program needs to support multiple cultures? Since you have turned a date into a string, you lose the ability to accurately sort on it or to format it for other cultures. The comment by Timothy G is the correct way to solve this problem. – Dave Holden May 13 '21 at 18:58