Along the same lines. set var x datetime = (datetime( rdate(...), rtime(...))
On Fri, May 21, 2021 at 2:07 PM Dan Goldberg <[email protected]> wrote: > Thx I will give that a try. > > > > Dan Goldberg > > > > > > *From:* [email protected] <[email protected]> *On Behalf Of > *Tony IJntema > *Sent:* Friday, May 21, 2021 10:52 AM > *To:* [email protected] > *Subject:* Re: [RBASE-L] - change date to datetime > > > > > > Dan, > > > > Try this: > > Create a new column like date_time_field DATETIME in the table > > Then perform the next statement (where datefield is the original date > column) > > > > UPDATE Testdate SET date_time_field = (DATETIME(datefield,00:00)) > > > > Tony > > > > > > Op 21-05-2021 om 19:18 schreef Dan Goldberg: > > I am trying to change a date column to datetime and it is giving me this > error. > > > > > > How do I change it? Do I have to do a unload/change it/load? > > > > TIA > > > > Dan Goldberg > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CAE33%40EXCHANGE10 > <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CAE33%40EXCHANGE10?utm_medium=email&utm_source=footer> > . > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/223ad65e-2368-e241-81e4-4452e7220448%40cio-bv.nl > <https://groups.google.com/d/msgid/rbase-l/223ad65e-2368-e241-81e4-4452e7220448%40cio-bv.nl?utm_medium=email&utm_source=footer> > . > > -- > For group guidelines, visit > http://www.rbase.com/support/usersgroup_guidelines.php > --- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CB0F5%40EXCHANGE10 > <https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014E8CB0F5%40EXCHANGE10?utm_medium=email&utm_source=footer> > . > -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CADeqk-5Ldq-7NzBwGdmiV06-g1qbmfY2cFN4R6QaG%2B5g0my-4g%40mail.gmail.com.
