SQL Server

Get and Set the Email Date (Local Timezone)

Demonstrates the Chilkat Email.LocalDateStr property, which is the date/time from the Date header returned in the local timezone in RFC822 string form (for example, Fri, 10 Jul 2026 15:15:30 -0500). Setting this property updates the email's Date header. Use LocalDate when a native local date/time value is preferred. This example sets the date and reads it back.

Background: An RFC822 date ends with a timezone: either GMT (equivalently +0000) or a signed offset like -0500, which means five hours behind UTC. The trailing offset is the only difference between the local and GMT views — they describe the identical moment in time. LocalDateStr presents the Date header using the running computer's local offset, while EmailDateStr presents it in GMT.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    --  Demonstrates the Email.LocalDateStr property.
    --  This is the date/time from the Date header returned in the local timezone,
    --  in RFC822 string form.  Setting it updates the email's Date header.

    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @email, 'LocalDateStr', 'Fri, 10 Jul 2026 15:15:30 -0500'


    EXEC sp_OAGetProperty @email, 'LocalDateStr', @sTmp0 OUT
    PRINT 'LocalDateStr = ' + @sTmp0

    EXEC @hr = sp_OADestroy @email


END
GO