Retrieve Stored Procedure compiled time zone

Database
Enthusiast

Retrieve Stored Procedure compiled time zone

Hi everyone, 

we faced a problem today because a Stored Procedure was compile in another Time Zone as desired. 

All timestamps imported were shifted and it took some hours to identify the cause. 

Is there any way to get the time zone used in the session where the SP was compiled?

 

Best regards, 

Paul

Kind regards,
Paul Hernandez

Accepted Solutions
Highlighted
Ambassador

Re: Retrieve Stored Procedure compiled time zone

Hi,

Try "Help Procedure proc-name ATTRS;"

 

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
1 ACCEPTED SOLUTION
1 REPLY 1
Highlighted
Ambassador

Re: Retrieve Stored Procedure compiled time zone

Hi,

Try "Help Procedure proc-name ATTRS;"

 

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com