5/13/2019 1:01 PM | |
Joined: 11/29/2017 Last visit: 9/4/2024 Posts: 19 Rating: (0) |
and the last one, |
5/14/2019 4:04 PM | |
Joined: 9/19/2009 Last visit: 9/21/2024 Posts: 459 Rating: (85) |
Hi There is severals ways to resolve this: 1.-The most easy, if you want the Datetime system = Now = Date & Time , when you build your query use the system function of SQL Server GETDATE(), sample:
2.-If you don´t know the format of SQLServer Open SQLServer Management Studio and again use the system function GETDATE() SELECT GETDATE(), now you will now the format 3.-If you want, try my library and use the function string :GetDateTimeFormat(string format) format (HH:mm:ss.fff) ; format (MMMM dd, yyyy) ; format (yyyyMMddHHmmss) Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
This contribution was helpful to2 thankful Users |
Follow us on