|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 19th, 2005, 09:44 PM
|
|||
|
|||
|
DateTime Conversion and Comparison
Hi All,
New to SQL and I'm having some trouble trying to do something simple. I need to pull data from a table that is corresponding to a month that is determine by the user. I have created a stored procedure and it looks like this create procedure uspBkMth @Mth char(10) as select @Mth = @Mth + '%' select dte from tblTest where cast(dte as char(10)) like @Mth Somehow the above procedure returns nothing when I execute as below : exec uspBkMth 'Dec' tblTest stored dte in datetime format and I'm using MS SQL. Can someone help me with this? Thanks in advance Jon
|
|
#2
March 21st, 2005, 10:25 AM
|
||||
|
||||
|
Try this
Code:
CREATE PROCEDURE dbo.uspBkMnth @intMonth integer -- make them enter a number instead of text. AS SelectdteFromtblTestwhere(MONTH(dte)= @intMonth)
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > DateTime Conversion and Comparison |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
