Get a Date Label from a java.sql.Timestamp Object : Date Time Timestamp « Database « Java Tutorial

1. Java Tutorial
2. Database
3. Date Time Timestamp

import java.sql.Timestamp;

public class MainClass {

  private static final long One_Day_In_Milliseconds = 86400000;

  public static final String DATE_LABEL_TODAY = "Today";

  public static final String DATE_LABEL_YESTERDAY = "Yesterday";

  public static final String DATE_LABEL_THIS_MONTH = "This Month";

  public static final String DATE_LABEL_OLDER = "Older";

  public static final String DATE_LABEL_NONE = "";

  public static java.sql.Timestamp getTimestamp() {
    java.util.Date today = new java.util.Date();
    return new java.sql.Timestamp(today.getTime());
  }

  public static String getDateLabel(java.sql.Timestamp ts, java.sql.Timestamp now) {
    long tsTime = ts.getTime();
    long nowTime = now.getTime();
    long quotient = (nowTime - tsTime) / One_Day_In_Milliseconds;

    if (quotient < 1) {
      return DATE_LABEL_TODAY;
    } else if (quotient < 2) {
      return DATE_LABEL_YESTERDAY;
    } else if (quotient < 30) {
      return DATE_LABEL_THIS_MONTH;
    } else {
      return DATE_LABEL_OLDER;
    }
  }

  public static void main(String[] args) {
    java.sql.Timestamp now = getTimestamp();

    java.sql.Timestamp ts1 = getTimestamp();
    System.out.println(getDateLabel(ts1, now));
    System.out.println(ts1.toString());
    System.out.println("-------------");

    // timestamp in format yyyy-mm-dd hh:mm:ss.fffffffff
    java.sql.Timestamp ts22 = java.sql.Timestamp.valueOf("2007-01-06 09:01:10");
    System.out.println(getDateLabel(ts22, now));
    System.out.println(ts22.toString());
    System.out.println("-------------");

    java.sql.Timestamp ts2 = java.sql.Timestamp.valueOf("2007-02-02 10:10:10");
    System.out.println(getDateLabel(ts2, now));
    System.out.println(ts2.toString());
    System.out.println("-------------");

    java.sql.Timestamp ts3 = java.sql.Timestamp.valueOf("2004-07-18 10:10:10");
    System.out.println(getDateLabel(ts3, now));
    System.out.println(ts3.toString());
    System.out.println("-------------");

    java.sql.Timestamp ts4 = java.sql.Timestamp.valueOf("2007-02-01 10:10:10");
    System.out.println(getDateLabel(ts4, now));
    System.out.println(ts4.toString());
    System.out.println("-------------");
  }
}

Today
2007-02-02 13:23:02.933
-------------
This Month
2007-01-06 09:01:10.0
-------------
Today
2007-02-02 10:10:10.0
-------------
Older
2004-07-18 10:10:10.0
-------------
Yesterday
2007-02-01 10:10:10.0
-------------