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 3: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 3:30:57 PM(UTC)
thomas

Rank: Paid support

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

Thanks: 21 times
Was thanked: 162 time(s) in 124 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 10:30:36 PM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 10,951

Thanks: 839 times
Was thanked: 416 time(s) in 394 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.

Scroll to Top