Hello
I export data from an H2 database and save it in a CSV.
That's going well.
I would like to save the age in another column.
Age = current date - Date of birth (GEBURTSDATUM)
Is that possible.
CALL
CSVWRITE('C:\Nextcloud-KCH\Vorstand\KC-Adressen\KC-Mitgliederadressen.csv',
'SELECT ANREDE,TITEL, NAME, VORNAME, STRASSE, PLZ, ORT, TELEFONPRIVAT,
HANDY, EINTRITT, GEBURTSDATUM, EMAIL
FROM PUBLIC.MITGLIED
WHERE BEITRAGSGRUPPE IS NOT 56 ORDER BY NAME, VORNAME asc',
'charset=windows-1250 escape=" fieldDelimiter=" fieldSeparator=;
writeColumnHeader=true');
Siegfried
--
You received this message because you are subscribed to the Google Groups "H2
Database" 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/h2-database/41476cd2-83e9-4d28-b825-8000ec80d148n%40googlegroups.com.
