Hello, everyone.
I have a parameter coming in to a stored procedure.
ALTER PROCEDURE [dbo].[udp_GetPriority]
@CurrentDateTime DATETIME
It's defaulted to 12:00AM as the hour, and I'd like to set the time in the T-SQL statement before running my query.
I didn't see an obvious method jump out as I was digging through the help files on DateTime types.
I saw where you can pull things out with DatePart() but not the syntax or methods to write back.
Any suggestions would be great.
(PS: I don't have the source code of the calling program or I'd just have it send in the time with the hour set as needed.)
Thanks, All.
Patrick
I have a parameter coming in to a stored procedure.
ALTER PROCEDURE [dbo].[udp_GetPriority]
@CurrentDateTime DATETIME
It's defaulted to 12:00AM as the hour, and I'd like to set the time in the T-SQL statement before running my query.
I didn't see an obvious method jump out as I was digging through the help files on DateTime types.
I saw where you can pull things out with DatePart() but not the syntax or methods to write back.
Any suggestions would be great.
(PS: I don't have the source code of the calling program or I'd just have it send in the time with the hour set as needed.)
Thanks, All.
Patrick