Pauls Blog

A good read.    Deciding between COALESCE and ISNULL in SQL Server (mssqltips.com) Key Points :  The COALESCE and ISNULL SQL Server statements handle data type precedence differently COALESCE determines the type (and length) of the output based on data type precedence.   ISNULL takes the first parameter.  The SQL Server COALESCE statement supports more than two arguments COALESCE and ISNULL perform about the same (in  most  cases) in SQL Server ISNULL is not consistent across Microsoft products/languages COALESCE is ANSI standard

 Press  shift - alt -s in VS Code Then select "SignCurrentScript"

  SELECT      a. ZDIRECTORY || '/' || a. ZFILENAME LocationOnFileSystem      , att. ZORIGINALFILENAME FROM ZADDITIONALASSETATTRIBUTES att JOIN ZASSET a ON att. ZASSET = a. Z_PK      -- WHERE att.ZORIGINALFILENAME = 'IMG_0938.JPG'      WHERE a. ZFILENAME = '6E44872E-FA7C-424A-9136-6B0DC24D7E8F.jpeg' NB: the photo is located at: /Users/ username /Pictures/Photos Library.photoslibrary/originals The sqlite file is at: /Users/ username /Pictures/Photos Library.photoslibrary/database/Photos.sqlite If you want the time, just grab , a. ZDATECREATED This is the seconds since Monday, 1 January 2001 12:00:00 AM or "Apple Cocoa Core Data timestamp"