Ver Mensaje Individual
  #1 (permalink)  
Antiguo 24/04/2012, 15:29
jerrymix
 
Fecha de Ingreso: abril-2012
Mensajes: 7
Antigüedad: 12 años
Puntos: 0
instruccion para fecha

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',