I believe this is what you are looking for. SELECT DATEADD(second, 1033606209, '01/01/1970') AS TheDate
Jerod M. Bennett Director of Media Production Pixelpushers, Inc. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Balaji Sent: Wednesday, October 02, 2002 6:10 PM To: [EMAIL PROTECTED] Subject: RE: [IMail Forum] How to format lastlogin from external database? Thank you scott, But now I need to find a solution to write an sql statement based on that date conversion. Thank you Balaji. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of R. Scott Perry Sent: Wednesday, October 02, 2002 5:59 PM To: [EMAIL PROTECTED] Subject: Re: [IMail Forum] How to format lastlogin from external database? >We use Imail 7.05 with Sql2000 external database. > >I would like to know how to convert the last login date from the >Database column name LASTLOGIN. > >I see the value 1033585273 and I logged in again to check the date >change and it shows 1033606209. > >How to interpret the date "1033606209" to a actual date format. That looks like the standard Unix time format, which is the number of seconds since January 1, 1970. http://www.onlineconversion.com/unix_time.htm shows that 1033606209 would be Thu, 3 Oct 2002 00:50:09 UTC. -Scott --- Declude: Anti-virus, Anti-spam and Anti-hijacking solutions for IMail. http://www.declude.com --- [This E-mail was scanned for viruses by Declude Virus (http://www.declude.com)] To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
