Or create another column as datetime, update that column with the original data , drop the date column and rename the new one to the original . It's early in the morning just a passing thought.
On Sat, 22 May 2021, 4:29 am Ken Shapiro, <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/rbase-l/CADeqk-5Ldq-7NzBwGdmiV06-g1qbmfY2cFN4R6QaG%2B5g0my-4g%40mail.gmail.com?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/CABnhDATftA3J8-nWp8%2BgS2juiuhtRUU3%3Dp2pNftij17XEwA53g%40mail.gmail.com.
