SQL Query - Datetime issue - VisualCron

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

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

omaresp
No customer Topic Starter

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

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official 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
No customer Topic Starter

2014-11-21T18:28:20Z

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

Siju Menon
No customer

2014-11-21T20:59:18Z

you can use convert in your case, something like:

select convert(varchar,getdate(),121)

Support
Official 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!