Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
vamsidhar.tangutoori
Starting Member
19 Posts |
Posted - 2013-10-19 : 11:04:20
|
Hi,I have writen a nested stored procedure when i am passing a datetime paramter from the first procedure into the internally called procedure it is dropping the time part, can someone please help me how to fix thisEX;Declare @pdate datetimeExec sp1 @pDate<this is datetime> = '2013-10-19 14:00:00'Create proc sp1(@pdate datetime)asBegin try Exec sp2 @pdate <this is the same parameter for sp1>End tryBegin Catch Select 'error'end catch |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-10-19 : 13:48:18
|
You will need to show us the code of the stored procedures.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|