This isn't actually the answer of the format, but you can export the results into sql statements and then erase teh old logins:
http://support.ipswitch.com/kb/IM-19990527-DM06.htm ----- Original Message ----- From: "Balaji" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 7:19 PM Subject: [IMail Forum] How to format lastlogin from external database? > Hello, > > 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. > > I couldn't find any documentation in Archives or Knowledgebase. > > This is basically to get the list of non active accounts. > > Any help is appreciated. > > Thank you > Balaji. > > > 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/
