This article will not help you to get a results of users based on parameters( In our table like free users or paid users.)
If we can format the table column LASTLOGIN value, it will be simpler to get reports what ever we want. Thank you Balaji. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sergio Rinc�n J. Sent: Wednesday, October 02, 2002 5:36 PM To: [EMAIL PROTECTED] Subject: Re: [IMail Forum] How to format lastlogin from external database? 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/ 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/
