Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
SET ThousandSep=',';SET DecimalSep='.';SET MoneyThousandSep=',';SET MoneyDecimalSep='.';SET MoneyFormat='$#,##0.00;-$#,##0.00';SET TimeFormat='hh:mm:ss TT';SET DateFormat='DD/MM/YYYY';SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';SET MonthNames='Ene;Feb;Mar;Abr;May;Jun;Jul;Ago;Sep;Oct;Nov;Dic';SET DayNames='Lun;Mar;Mi�;Jue;Vie;S�b;Dom';ODBC CONNECT TO [Qlik view Capital Humano] (XUserId is XEPCSCRIXCVB, XPassword is KdKOeSRMXDfB);CAPITAL_HUMANO:LOAD Idregistro, Empresa, EmpFicha as Ficha, EmpFechaingreso, EmpFechaBaja, EmpEstadoEmpleado,.... AsgContrato, FechaActualizacion, DAY("FechaActualizacion") AS [DAY], WEEK("FechaActualizacion") AS [WEEK], Day(FechaActualizacion) & '-' & Month(FechaActualizacion) AS FechaDMI, MONTH("FechaActualizacion") AS [MONTH];SQL SELECT *FROM EDW.dbo.Empleados;Store CAPITAL_HUMANO into cAPITAL_HUMANO_2010.qvd;I would like to select some dates from the field FechaActualizacion (imestampFormat) I'm sure about the syntax of the date I want to select. I try this: SQL SELECT * where [FechaActualizacion] = '07/01/2010 12:00:00 a.m.' and where [FechaActualizacion] = '02/02/2010 12:00:00 a.m.' Can somebody tell me how to do it? I will really apreciate any help in solving this isue. Patrick
SQL SELECT *FROM EDW.dbo.Empleados where FechaActualizacion </body>
Hi Dewaegep,
As you say,your syntax is write ,i suggest you to try like
select * from table
where date>=' ' and date <= ' ' ; pls make sure formate of date is supporting your date formate.
regard's
Naren.
SQL SELECT *FROM EDW.dbo.Empleados where FechaActualizacion </body>
intenta con
SQL SELECT * from ... where [FechaActualizacion] between '07/01/2010' and '02/02/2010'