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


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?
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!
omaresp
2014-11-21T18:28:20Z
We should be able to choose the format. Just like you did for parameters in stored procedures.
Guest
2014-11-21T20:59:18Z
you can use convert in your case, something like:

select convert(varchar,getdate(),121)
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!
Scroll to Top