5 Replies Latest reply: Jun 25, 2012 1:10 PM by Stefan Wühl RSS

    Converting date/timestamp

      LOAD

       

      UserName,
      FirstName,
      LastName,
      Title,
      OU,
      Department,
      Location,
      Emailaddress,
      WhenCreated,
      PaswordLastChanged,
      LastLogonTime,
      AccControl,
      Status,
      PasswordAge,
      AccountLockout,
      AccountExpirationDate,
      NextPwdReset,
      MFID,
      Description,
      Manager,
      SSO,
      "NON_Human";

      SQL
      SELECT UserName,
      FirstName,
      LastName,
      Title,
      OU,
      Department,
      Location,
      Emailaddress,
      WhenCreated,
      PaswordLastChanged,
      LastLogonTime,
      AccControl,
      Status,
      PasswordAge,
      AccountLockout,
      AccountExpirationDate,
      NextPwdReset,
      MFID,
      Description,
      Manager,
      SSO,
      "NON_Human"
      FROM

       

       

      I have a field that contains a date and a timestamp. Its the "LastLogonTime" field. I want to convert the timestamp in all of them to the same thing, all zero's. I want to do it in the script.

       

      After I get that done I want to compare dates. So flag dates that are older than 60 days or 180 days. I want to do that in the front end.

       

      Thank you!