SELECT
FirstName,
LastName,
Address,
FirstName ||' '|| LastName || ' ' || Address ||','|| City ||' '||State ||' '||PostalCode as [Mailing Address],
length(PostalCode),
substr(PostalCode,1,5) as [5 digit postal code],
upper(FirstName) as [First Name all caps],
lower(LastName) as [Last Name all lower],
strftime('%Y-%m-%d',BirthDate) as [BirthDate without time code],
strftime('%Y-%m-%d','now')-strftime('%Y-%m-%d',BirthDate) as age
from Employee
Showing posts with label Getting the age of employees from their birthdate in sql. Show all posts
Showing posts with label Getting the age of employees from their birthdate in sql. Show all posts
Tuesday, February 20, 2024
Getting the age of employees from their birthdate in sql
Subscribe to:
Posts (Atom)