Hi Razzak and Albert, thank you for fast and always helpful advice ! Fritz -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von A. Razzak Memon Gesendet: Mittwoch, 18. Juni 2014 17:02 An: RBASE-L Mailing List Betreff: [RBASE-L] - Re: varchar-Text/Datetime-Date
At 10:51 AM 6/18/2014, Dr. Fritz Luettgens wrote: >Hi, >I hav imported an access-db table into rbase. >In the imported table exits a varchar and a datetime column. >How can I change >varchhar to TEXT and >datetime to DATE >Any idea helps Fritz, You can easily convert the VARCHAR data to NOTE data! Here's how: Example: TableA: ColumnA INTEGER ColumnB VARCHAR TableB: ColumnA INTEGER ColumnC NOTE Routine to convert VARCHAR to NOTE Field: INSERT INTO TableB (ColumnA, ColumnC) SELECT ColumnA, ColumnB FROM TableA The resulting ColumnC in TableB will include the converted VARCHAR to NOTE. That's all there is to it! In reference to converting DateTime to DATE, use (DEXTRACT(datetime)) function to achieve your goal. Feel free to reach out to me with any questions. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
