Community forum

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

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline SWJMcC  
#1 Posted : Friday, July 3, 2015 2:49:50 PM(UTC)
SWJMcC

Rank: No customer

Joined: 8/26/2014(UTC)
Posts: 1
United Kingdom
Location: ENGLAND, COLCHESTER

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 ?
Offline thomas  
#2 Posted : Sunday, July 5, 2015 2:30:57 PM(UTC)
thomas

Rank: Paid support

Joined: 12/10/2013(UTC)
Posts: 167
Norway

Thanks: 14 times
Was thanked: 56 time(s) in 41 post(s)
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
thanks 1 user thanked thomas for this useful post.
Support on 7/5/2015(UTC)
Offline Support  
#3 Posted : Sunday, July 5, 2015 9:30:36 PM(UTC)
Support

Rank: Official support

Medals:
Joined: 2/23/2008(UTC)
Posts: 9,404

Thanks: 573 times
Was thanked: 326 time(s) in 314 post(s)
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!
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2016, Yet Another Forum.NET
This page was generated in 0.139 seconds.
Scroll to Top