instruccion para fecha

jerrymix · #1 (**permalink**) 24/04/2012, 15:29

tengo esta instruccion en mi query solo que quiero que solo me de las fechas superiores al 2012 por que al momento de ejecutarlo me da desde el inicio de operaciones de mi base de datos POR FAVOR ESPERO SUS COMENTARIOS

SELECT case when Datepart(Month, T0.DocDate) = 1
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-01 ' WHEN Datepart(Month, T0.DocDate)= 2
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-02 ' WHEN Datepart(Month, T0.DocDate)= 3
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-03 ' WHEN Datepart(Month, T0.DocDate)= 4
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-04 ' WHEN Datepart(Month, T0.DocDate)= 5
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-05 ' WHEN Datepart(Month, T0.DocDate)= 6
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-06 ' WHEN Datepart(Month, T0.DocDate)= 7
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-07 ' WHEN Datepart(Month, T0.DocDate)= 8
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-08 ' WHEN Datepart(Month, T0.DocDate)= 9
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-09 ' WHEN Datepart(Month, T0.DocDate)= 10
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-10 ' WHEN Datepart(Month, T0.DocDate)= 11
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-11 ' WHEN Datepart(Month, T0.DocDate)= 12
THEN CAST(Datepart(year, T0.DocDate) AS varchar(30)) + '-12 ' ELSE 'bones' END AS 'Periodo',

iislas · #2 (**permalink**) 24/04/2012, 18:00

No es mas sencillo:

WHERE YEAR(tucolumna) >= 2012

jerrymix · #3 (**permalink**) 25/04/2012, 08:19

no entendi donde debere poner el where

jerrymix · #4 (**permalink**) 25/04/2012, 08:31

ya me quedo muchas gracias iislas, ahora solo una pregunta y si yo quisiera ponerle lo mayor al mes de abril? como deberia ser la instruccion

Libras · #5 (**permalink**) 25/04/2012, 08:37

Cita:

Iniciado por jerrymix

no entendi donde debere poner el where

Madre mia que pregunta :S

Código SQL:

Ver originalSELECT CASE WHEN Datepart(MONTH, T0.DocDate) = 1
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-01 ' WHEN Datepart(MONTH, T0.DocDate)= 2
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-02 ' WHEN Datepart(MONTH, T0.DocDate)= 3
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-03 ' WHEN Datepart(MONTH, T0.DocDate)= 4
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-04 ' WHEN Datepart(MONTH, T0.DocDate)= 5
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-05 ' WHEN Datepart(MONTH, T0.DocDate)= 6
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-06 ' WHEN Datepart(MONTH, T0.DocDate)= 7
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-07 ' WHEN Datepart(MONTH, T0.DocDate)= 8
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-08 ' WHEN Datepart(MONTH, T0.DocDate)= 9
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-09 ' WHEN Datepart(MONTH, T0.DocDate)= 10
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-10 ' WHEN Datepart(MONTH, T0.DocDate)= 11
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-11 ' WHEN Datepart(MONTH, T0.DocDate)= 12
THEN CAST(Datepart(YEAR, T0.DocDate) AS VARCHAR(30)) + '-12 ' ELSE 'bones' END AS 'Periodo' WHERE YEAR(tucolumna) >= 2012 AND datepart(mm,tucolumna) >=4

En el query viene lo del mes tambien :)

jerrymix · #6 (**permalink**) 25/04/2012, 08:43

gracias amigo iislas ya quedo resuelto el dato agradezco mucho tu ayuda saludos

jerrymix · #7 (**permalink**) 25/04/2012, 08:44

gracias a todos estaba dormido en esto pero ya quedo con la ayuda de antemano mil gracias

iislas · #8 (**permalink**) 25/04/2012, 11:46

Libras

Soy tu fan........