topic Re: Insert date in table in QlikView

Insert date in table

Fri, 20 Nov 2020 18:02:30 GMT

Insert date in table:

Hello, I need help to insert the current date in table Cortes_saa I'm creating from a view. I tried various form but I can not do it. Thank You

Cortes_saa:

LOAD *;

SQL SELECT

ReloadTime () corte_saa as,

vta_crr_codigo,

vta_pca_codigo,

vta_alc_ano_ingreso

FROM Academia.dbo "VTA_ALUMNO_CARRERA.";

Re: Insert date in table

maxgro — Thu, 09 Jul 2015 18:52:40 GMT

ortes_saa:

LOAD

today() as corte_saa as; // or now() for timestamp

SQL SELECT

vta_crr_codigo,

vta_pca_codigo,

vta_alc_ano_ingreso

FROM Academia.dbo "VTA_ALUMNO_CARRERA.";

Re: Insert date in table

daniel_kusiak — Thu, 09 Jul 2015 19:05:33 GMT

Try:

LOAD

today() as corte_saa;

SQL SELECT

vta_crr_codigo,

vta_pca_codigo,

vta_alc_ano_ingreso

FROM Academia.dbo "VTA_ALUMNO_CARRERA.";

U cant place reloadtime in SQL SELECT statment. It should be in LOAD statment. And when you are using alias you must give it a name -> "something as something".

Re: Insert date in table

Thu, 09 Jul 2015 19:09:11 GMT

Muchas gracias, me funciono

Re: Insert date in table

Thu, 09 Jul 2015 20:25:11 GMT

I worked, thank you very much

Re: Insert date in table

Thu, 09 Jul 2015 20:25:22 GMT

I worked, thank you very much