Class DateUtil

java.lang.Object
com.almis.awe.model.util.data.DateUtil

public final class DateUtil extends Object
DateUtil Class Date Utilities for AWE
Author:
Pablo GARCIA and Pablo Vidal - 13/JUL/2014
  • Field Details

  • Method Details

    • web2SqlDate

      public static Date web2SqlDate(String date)
      Transforms a web date into a SQL Date
      Parameters:
      date - Web Date
      Returns:
      SQL Date
    • web2SqlTime

      public static Time web2SqlTime(String time)
      Transforms a web timestamp into a SQL Timestamp
      Parameters:
      time - Web Timestamp
      Returns:
      SQL Date
    • webDate2SqlTimestamp

      public static Timestamp webDate2SqlTimestamp(String date)
      Transforms a web date into a SQL Timestamp
      Parameters:
      date - Web Date
      Returns:
      SQL Timestamp
    • web2SqlTimestamp

      public static Timestamp web2SqlTimestamp(String timestamp)
      Transforms a web timestamp into a SQL Timestamp
      Parameters:
      timestamp - Web Timestamp
      Returns:
      SQL Timestamp
    • web2Date

      public static Date web2Date(String date)
      Transforms a web date (dd/MM/yyyy[ HH:mm:ss]) into a Date Return null if date is not valid
      Parameters:
      date - string Web date
      Returns:
      Date
    • web2Time

      public static Date web2Time(String time)
      Transforms a web time into a Date Return null if time is not valid
      Parameters:
      time - Web Time
      Returns:
      SQL Date
    • web2Timestamp

      public static Date web2Timestamp(String timestamp)
      Transforms a web timestamp into a Date
      Parameters:
      timestamp - Web Timestamp date
      Returns:
      timestamp Date
    • web2TimestampWithMs

      public static Date web2TimestampWithMs(String date)
      Transforms a web timestamp with ms into a Date
      Parameters:
      date - Web Date
      Returns:
      SQL Date
    • dat2SqlDate

      public static Date dat2SqlDate(Date date)
      Transforms a date into a SQL Date
      Parameters:
      date - Date
      Returns:
      SQL Date
    • dat2SqlDateString

      public static String dat2SqlDateString(Date date)
      Transforms a date into a SQL Date
      Parameters:
      date - Date
      Returns:
      SQL Date
    • sqlTimestamp2Date

      public static Date sqlTimestamp2Date(Timestamp timestamp)
      Transforms a sql timestamp into a java Date
      Parameters:
      timestamp - Date
      Returns:
      SQL Date
    • sqlDate2Date

      public static Date sqlDate2Date(Date date)
      Transforms a sql date into a java Date
      Parameters:
      date - Date
      Returns:
      SQL Date
    • dat2SqlTimestamp

      public static Timestamp dat2SqlTimestamp(Date date)
      Transforms a date into a SQL Time
      Parameters:
      date - Date
      Returns:
      SQL Timestamp
    • dat2SqlTimeString

      public static String dat2SqlTimeString(Date date)
      Transforms a timestamp date into a SQL Timestamp string
      Parameters:
      date - Date
      Returns:
      SQL Timestamp
    • dat2WebTimestamp

      public static String dat2WebTimestamp(Date dateTime)
      Transforms a date time into a Web Timestamp
      Parameters:
      dateTime - Date
      Returns:
      WEB Timestamp
    • dat2WebTimestampMs

      public static String dat2WebTimestampMs(Date date)
      Transforms a date into a Web Timestamp with milliseconds
      Parameters:
      date - dateTime Date
      Returns:
      WEB Timestamp
    • dat2WebTime

      public static String dat2WebTime(Date date)
      Transforms a time as Date into a Web Time
      Parameters:
      date - Date
      Returns:
      WEB Time
    • dat2WebDate

      public static String dat2WebDate(Date date)
      Transforms a date into a Web Date
      Parameters:
      date - Date
      Returns:
      String WEB date
    • dat2DateMs

      public static String dat2DateMs(Date date)
      Transforms a java Date into a date in milliseconds (Used in charts)
      Parameters:
      date - Date
      Returns:
      string date in milliseconds
    • sql2WebDate

      public static String sql2WebDate(String date)
      Transforms a SQL String date into a web date
      Parameters:
      date - SQL String Date
      Returns:
      Web date formatted
    • sql2JavaDate

      public static Date sql2JavaDate(String timestamp)
      Transforms a SQL String date into a java date
      Parameters:
      timestamp - SQL String Timestamp
      Returns:
      Web date formatted
    • sqlDate2JavaDate

      public static Date sqlDate2JavaDate(String date)
      Transforms a SQL String date (without time) into a java date
      Parameters:
      date - SQL String Date
      Returns:
      Web date formatted
    • wbs2JavaDate

      public static Date wbs2JavaDate(String date)
      Transforms a WBS String date into a java date
      Parameters:
      date - SQL String Date
      Returns:
      Web date formatted
    • rdb2Date

      public static Date rdb2Date(String date)
      Transforms a RDB String date into a java date
      Parameters:
      date - SQL String Date
      Returns:
      Web date formatted
    • sql2WebTime

      public static String sql2WebTime(String timestamp)
      Transforms a SQL String date into a web time
      Parameters:
      timestamp - SQL String Date
      Returns:
      Web time formatted
    • sql2WebTimestamp

      public static String sql2WebTimestamp(String date)
      Transforms a SQL String date into a web timestamp
      Parameters:
      date - SQL String Date
      Returns:
      Web timestamp formatted
    • sql2JsDate

      public static String sql2JsDate(String date)
      Transforms a SQL String date into a js date
      Parameters:
      date - SQL String Date
      Returns:
      Web date formatted
    • sql2DateMs

      public static String sql2DateMs(String val)
      Parse sql date to java date in milliseconds
      Parameters:
      val - Sql date
      Returns:
      Java date in milliseconds
    • sql2JsTimestamp

      public static String sql2JsTimestamp(String date)
      Transforms a SQL String date into a js timestamp
      Parameters:
      date - SQL String Date
      Returns:
      Web timestamp formatted
    • sqlDat2WebDate

      public static String sqlDat2WebDate(Date date)
      Transforms a SQL String date into a web date
      Parameters:
      date - SQL String Date
      Returns:
      Web date formatted
    • sqlDat2WebTime

      public static String sqlDat2WebTime(Time date)
      Transforms a SQL String date into a web time
      Parameters:
      date - SQL String Date
      Returns:
      Web time formatted
    • sqlDat2WebTimestamp

      public static String sqlDat2WebTimestamp(Timestamp date)
      Transforms a SQL String date into a web timestamp
      Parameters:
      date - SQL String Date
      Returns:
      Web timestamp formatted
    • sqlDat2JsDate

      public static String sqlDat2JsDate(Date date)
      Transforms a SQL String date into a web date
      Parameters:
      date - SQL String Date
      Returns:
      Web date formatted
    • sqlDat2JsTimestamp

      public static String sqlDat2JsTimestamp(Timestamp date)
      Transforms a SQL String date into a js timestamp
      Parameters:
      date - SQL String Date
      Returns:
      Web timestamp formatted
    • dat2JsDate

      public static String dat2JsDate(Date date)
      Transforms a Date into a js date
      Parameters:
      date - SQL String Date
      Returns:
      Web timestamp formatted
    • dat2JsTimestamp

      public static String dat2JsTimestamp(Date date)
      Transforms a Date into a js timestamp
      Parameters:
      date - SQL String Date
      Returns:
      Web timestamp formatted
    • sqlDat2WebTimestampWithMs

      public static String sqlDat2WebTimestampWithMs(Timestamp date)
      Transforms a SQL String date into a web timestamp with Milliseconds
      Parameters:
      date - SQL String Date
      Returns:
      Web timestamp formatted
    • web2WbsDate

      public static String web2WbsDate(String date)
      Transforms a web date into a web service date
      Parameters:
      date - (Web formatted)
      Returns:
      Web Service date formatted
    • dat2WbsDate

      public static String dat2WbsDate(Date date)
      Transforms a date into a web service date
      Parameters:
      date - (Web formatted)
      Returns:
      Web Service date formatted
    • web2RdbDate

      public static String web2RdbDate(String date)
      Transforms a web date into an RDB date (23-OCT-1978)
      Parameters:
      date - (Web formatted)
      Returns:
      RDB date formatted
    • wbs2WebDate

      public static String wbs2WebDate(String date)
      Transforms a web service date into a web date
      Parameters:
      date - (Web service formatted)
      Returns:
      Web date formatted
    • wbs2JsDate

      public static String wbs2JsDate(String date)
      Transforms a web service date into a js date
      Parameters:
      date - (Web service formatted)
      Returns:
      Web date formatted
    • getSystemDate

      public static String getSystemDate()
      Returns system date in SQL timestamp format (yyyy-MM-dd HH:mm:ss.SSS)
      Returns:
      String SQL system date
    • getCalendarDate

      public static Calendar getCalendarDate(String strSqlDate)
      Returns Calendar object for string Date with SQL format
      Parameters:
      strSqlDate - SQL Date
      Returns:
      Calendar object
    • isWebDate

      public static boolean isWebDate(String date)
      Returns true if date is an WEB date
      Parameters:
      date - (Web service formatted)
      Returns:
      Is an WEB date
    • isWbsDate

      public static boolean isWbsDate(String date)
      Returns true if date is an WBS date
      Parameters:
      date - (Web service formatted)
      Returns:
      Is an WBS date
    • isSqlDate

      public static boolean isSqlDate(String date)
      Returns true if date is an SQL date
      Parameters:
      date - (Web service formatted)
      Returns:
      Is an SQL date
    • isWebTimestamp

      public static boolean isWebTimestamp(String date)
      Returns true if date is a Web timestamp
      Parameters:
      date - (Web service formatted)
      Returns:
      Is an WBS date
    • isWebTimestampWithMs

      public static boolean isWebTimestampWithMs(String date)
      Returns true if date is a Web date with milliseconds
      Parameters:
      date - (Web service formatted)
      Returns:
      Is an WBS date
    • isJsonDate

      public static boolean isJsonDate(String date)
      Returns true if date is json date
      Parameters:
      date - (Web service formatted)
      Returns:
      Is an WBS date
    • jsonDate

      public static Date jsonDate(String date)
      Transforms a JSON Date to a Date object
      Parameters:
      date - JSON date
      Returns:
      Date OBJECT
    • jsonDate

      public static String jsonDate(Date date)
      Transforms a JSON Date from a Date object
      Parameters:
      date - JSON date
      Returns:
      Date OBJECT
    • getDateWithTimeFromCriteria

      public static Date getDateWithTimeFromCriteria(String date, String time)
      Build java Date object from date criteria with Time criteria
      Parameters:
      date - Date criteria [dd/MM/yyyy]
      time - Time criteria [HH:mm:ss]
      Returns:
      Object date from criterion's or null value if any criterion are null with format [dd/MM/yyyy HH:mm:ss]
    • addTimeToDate

      public static Date addTimeToDate(Date date, String time)
      Build java Date object from date criteria with Time criteria
      Parameters:
      date - Date criteria [dd/MM/yyyy]
      time - Time criteria [HH:mm:ss]
      Returns:
      Object date from criteria or null value if any criterion is null with format [dd/MM/yyyy HH:mm:ss]
    • generic2Date

      public static String generic2Date(String dateIn, String formatFrom, String formatTo)
      TransformColumn a date from a format to another date format
      Parameters:
      dateIn - Input date
      formatFrom - Initial date format
      formatTo - Final date format
      Returns:
      Date formatted
    • rdbDate2Web

      public static String rdbDate2Web(String date)
      Transforms an RDB date into a web date (23-OCT-1978)
      Parameters:
      date - (Web formatted)
      Returns:
      RDB date formatted
    • dat2RDBDate

      public static String dat2RDBDate(Date date)
      Transforms Date into an RDB String (23-OCT-1978)
      Parameters:
      date - (Web formatted)
      Returns:
      RDB date formatted
    • elapsedTime

      public static String elapsedTime(Long milliseconds, AweElements elements)
      Retrieve how much time has elapsed from milliseconds
      Parameters:
      milliseconds - Difference in milliseconds
      elements - AWE Elements
      Returns:
      Date since
    • dateSince

      public static String dateSince(Date date, AweElements elements)
      Retrieve how much time has elapsed since a date
      Parameters:
      date - Date to check
      elements - AWE Elements
      Returns:
      Date since
    • autoDetectDateFormat

      public static Date autoDetectDateFormat(String dateString)
      Autodetect date format and applies a format into java date
      Parameters:
      dateString - String date
      Returns:
      Date formatted
    • asLocalDate

      public static LocalDate asLocalDate(Date date)
      Calls asLocalDate(Date, ZoneId) with the system default time zone.
    • asLocalDate

      public static LocalDate asLocalDate(Date date, ZoneId zone)
      Creates LocalDate from java.util.Date or it's subclasses.
    • asLocalTime

      public static LocalTime asLocalTime(Date date)
      Calls asLocalTime(Date, ZoneId) with the system default time zone.
    • asLocalTime

      public static LocalTime asLocalTime(Date date, ZoneId zone)
      Creates LocalTime from java.util.Date or it's subclasses.
    • asLocalDateTime

      public static LocalDateTime asLocalDateTime(Date date)
      Calls asLocalDateTime(Date, ZoneId) with the system default time zone.
    • asLocalDateTime

      public static LocalDateTime asLocalDateTime(Date date, ZoneId zone)
      Creates LocalDateTime from java.util.Date or it's subclasses.
    • asUtilDate

      public static Date asUtilDate(Object date)
      Calls asUtilDate(Object, ZoneId) with the system default time zone.
    • asUtilDate

      public static Date asUtilDate(Object date, ZoneId zone)
      Creates a Date from various date objects. Is null-safe. Currently, supports:
      Parameters:
      zone - Time zone, used only if the input object is LocalDate or LocalDateTime.
      Returns:
      Date (exactly this class, not a subclass, such as java.sql.Date)
    • asInstant

      public static Instant asInstant(Date date)
      Creates an Instant from java.util.Date or it's subclasses. Null-safe.
    • asZonedDateTime

      public static ZonedDateTime asZonedDateTime(Date date)
      Calls asZonedDateTime(Date, ZoneId) with the system default time zone.
    • asZonedDateTime

      public static ZonedDateTime asZonedDateTime(Date date, ZoneId zone)
      Creates ZonedDateTime from java.util.Date or it's subclasses. Null-safe.