Time Zone Challenge - All Ideas Welcome

Hi all,

I have been tasked with an interesting challenge and was wondering if any of you experts out there might have any ideas on a solution. Basically, I have a table of packages:

CREATE TABLE [dbo].[tPackage] (
[PkgID] [int] NOT NULL PRIMARY KEY CLUSTERED ,
[PkgDelivZip] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PkgDelivDate] [smalldatetime] NULL ,
[HasBeenDeliv] [bit] NULL
) ON [PRIMARY]
GO

INSERT INTO tPackage VALUES (1, '30022', '11/9/06 10:30 am', 1)
INSERT INTO tPackage VALUES (2, '30022', '11/9/06 10:30 am', 0)
INSERT INTO tPackage VALUES (3, '30022', '11/9/06 06:00 pm', 0)
INSERT INTO tPackage VALUES (4, '96801', '11/9/06 10:30 am', 1)
INSERT INTO tPackage VALUES (5, '96801', '11/9/06 10:30 am', 0)
INSERT INTO tPackage VALUES (6, '96801', '11/9/06 06:00 pm', 0)


And I need to retrieve a list of those packages which are late for delivery. Now if location was not a factor, I could just use the simple script:

SELECT * FROM tPackage WHERE HasBeenDeliv = 0 AND PkgDelivDate < GetDate()

Unfortunately, in the case of package 5, it is not after 10:30am in Hawaii, so this should not be considered late. I thought about having a table of zipcodes with their timezone differential, but the really big problem comes in when you consider the areas which do not observe Daylight Savings Time.

Any thoughts?
Thanks in advance for your feedback!
Cat