SQL Date Time - VisualCron - Forum

Community forum

SWJMcC
2015-07-03T13:49:50Z
When I run a query on one machine I get date time in the following format
7/2/2015 12:00:00 AM.

When I run the same query on a different machine I get date time in the following format
7/2/2015 00:03:34

How can I set VISUALCRON to use the same datetime format ?
thomas
2015-07-05T13:30:57Z
Hi

In my opinion you should do the formatting in the query to be sure you always get the correct format. For example like this: SELECT CONVERT(varchar(30), getdate(), 104 ). You can find more formats in the link:

http://www.sql-server-he...m/tips/date-formats.aspx 
Support
2015-07-05T20:30:36Z
I agree with Thomas.

The output is related to the regional settings unless you explitly convert the output.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top