Community forum

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


  1. Forum
  2. Support
  3. General problem solving
  4. SQL Date Time
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 ?
 Reply
 View All Posts by User
Sponsor
Forum information
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 
 Reply
 View All Posts by User
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!
 Reply
 View All Posts by User
Similar Topics
Users browsing this topic
  1. Forum
  2. Support
  3. General problem solving
  4. SQL Date Time
 

© VisualCron

Scroll to Top