Insert date in table

[#1]

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.";

[maxgro]

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.";

[daniel_kusiak]

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".

[#4]

Muchas gracias, me funciono

[#5]

I worked, thank you very much

[#6]

I worked, thank you very much