
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Formato Fecha
Hola,
Tengo una base de datos con un formato de fecha que no me reconoce QV:
Debo trabajar con dimensiones como año, mes, día, hora, ésta última no está en formato de fecha militar, depende si es am o pm. ¿Qué debo hacer para que QV me lo reconozca como una fecha completa?
Gracias!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hola,
debes adaptar el campo Date&Time.
Suponiendo que le llamamos A a dicho campo:
Data:
LOAD
subfield(A, ' ',1) as Raw_Fecha,
subfield(A, ' ',2) as Raw_Hora,
subfield(A, ' ',3) as AMPM
FROM
[..\Libro1.xlsx]
(ooxml, no labels);
Data2:
load Raw_Fecha as Fecha,
if(AMPM='AM',Raw_Hora,
if(subfield(Raw_Hora,':',1)='12',(subfield(Raw_Hora,':',1)&right(Raw_Hora,6)),(subfield(Raw_Hora,':',1)+12)&right(Raw_Hora,6)))
as Hora
resident Data;
drop table Data;
Ahora tienes dos campos con la fecha y la hora.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mil gracias!!, salió perfecto!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
one solution could be also:
table1:
LOAD *,
Year(YourTimestamp) as YourYear,
Month(YourTimestamp) as YourMonth,
Day(YourTimestamp) as YourDay,
Hour(YourTimestamp) as YourHour,
Minute(YourTimestamp) as YourMinute,
Second(YourTimestamp) as YourSecond,
DayName(YourTimestamp) as YourDate,
Time(Frac(YourTimestamp)) as YourTime;
LOAD Date#(YourTimestamp,'M/DD/YYYY h:mm:ss TT') as YourTimestamp
Inline [
YourTimestamp
9/14/2015 9:32:02 AM
9/13/2015 7:03:10 PM
];
hope this helps
regards
Marco
