SQL Date Time - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

SWJMcC
No customer Topic Starter

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 ?

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

thomas
Free support

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
Official 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!