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 Query - Datetime issue
omaresp
2014-11-14T21:31:53Z
When I run a query from SQL I get a result with the following datetime format:

2014-11-13 00:00:00.000


The output however from VisualCron converts it to

11/13/2014 12:00:00 AM

Any ideas?
 Reply
 View All Posts by User
Sponsor
Forum information
Support
2014-11-15T12:16:58Z
I guess it is the default format for the culture that VisualCron runs in but you can always format the date in the query if you want a specific format.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
 Reply
 View All Posts by User
omaresp
2014-11-21T18:28:20Z
We should be able to choose the format. Just like you did for parameters in stored procedures.
 Reply
 View All Posts by User
Guest
2014-11-21T20:59:18Z
you can use convert in your case, something like:

select convert(varchar,getdate(),121)
 Reply
Support
2014-11-21T23:44:05Z
Originally Posted by: omaresp 

We should be able to choose the format. Just like you did for parameters in stored procedures.



You are not choosing format in stored procedures - you are choosing data type.
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 Query - Datetime issue
 

© VisualCron

Scroll to Top