Jump to content


rknechtel

Member Since 03 Apr 2016
Offline Last Active Jan 25 2018 08:59 PM
-----

Topics I've Started

Creating a list of Deaths

23 January 2018 - 07:31 PM

So I've been playing with SQLLiteSPy, I know SQL very well (use it for work for many years). I've been trying to build a quiery for generating a list of all males with age at death.

Basically what I'm looking for is:
Last Name (Surname) (NameTable)
First Name (Given) (NameTable)
Birth Date (Date from EventType 1 in EventTable)
Death Date (Date from EventType 2 in EventTable)
Age (Death Date - Birth Date) (EventTable)

 

I can figure out all of it except one data item. Figuring out how to "extract" the date" from the Date column in the EventTable.

Example Birth Date from EventTable"

D.+19400403..+00000000..

 

This is the data I'm trting to get out: 19400403

 

Does anyone know how to extract this data from the Date field in the EventTable?

 

I know there is some SQL on (https://sqlitetoolsf....wikispaces.com) - DateDecoder.sql - but seriously is that the ONLY way to extract this information? I tried to play with it but didn't get very far.

I have all my joins all figured out - just need to get the Date(s).

 

I'm running RM7

SQLLiteSpy 1.9.10

 

Thanks,