Package com.almis.awe.model.util.data
Class DateUtil
java.lang.Object
com.almis.awe.model.util.data.DateUtil
DateUtil Class
Date Utilities for AWE
- Author:
- Pablo GARCIA and Pablo Vidal - 13/JUL/2014
-
Field Summary
Modifier and TypeFieldDescriptionstatic final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
static final DateTimeFormatter
-
Method Summary
Modifier and TypeMethodDescriptionstatic Date
addTimeToDate
(Date date, String time) Build java Date object from date criteria with Time criteriastatic Instant
Creates anInstant
fromjava.util.Date
or it's subclasses.static LocalDate
asLocalDate
(Date date) CallsasLocalDate(Date, ZoneId)
with the system default time zone.static LocalDate
asLocalDate
(Date date, ZoneId zone) CreatesLocalDate
fromjava.util.Date
or it's subclasses.static LocalDateTime
asLocalDateTime
(Date date) CallsasLocalDateTime(Date, ZoneId)
with the system default time zone.static LocalDateTime
asLocalDateTime
(Date date, ZoneId zone) CreatesLocalDateTime
fromjava.util.Date
or it's subclasses.static LocalTime
asLocalTime
(Date date) CallsasLocalTime(Date, ZoneId)
with the system default time zone.static LocalTime
asLocalTime
(Date date, ZoneId zone) CreatesLocalTime
fromjava.util.Date
or it's subclasses.static Date
asUtilDate
(Object date) CallsasUtilDate(Object, ZoneId)
with the system default time zone.static Date
asUtilDate
(Object date, ZoneId zone) Creates aDate
from various date objects.static ZonedDateTime
asZonedDateTime
(Date date) CallsasZonedDateTime(Date, ZoneId)
with the system default time zone.static ZonedDateTime
asZonedDateTime
(Date date, ZoneId zone) CreatesZonedDateTime
fromjava.util.Date
or it's subclasses.static Date
autoDetectDateFormat
(String dateString) Autodetect date format and applies a format into java datestatic String
dat2DateMs
(Date date) Transforms a java Date into a date in milliseconds (Used in charts)static String
dat2JsDate
(Date date) Transforms a Date into a js datestatic String
dat2JsTimestamp
(Date date) Transforms a Date into a js timestampstatic String
dat2RDBDate
(Date date) Transforms Date into an RDB String (23-OCT-1978)static Date
dat2SqlDate
(Date date) Transforms a date into a SQL Datestatic String
dat2SqlDateString
(Date date) Transforms a date into a SQL Datestatic Timestamp
dat2SqlTimestamp
(Date date) Transforms a date into a SQL Timestatic String
dat2SqlTimeString
(Date date) Transforms a timestamp date into a SQL Timestamp stringstatic String
dat2WbsDate
(Date date) Transforms a date into a web service datestatic String
dat2WebDate
(Date date) Transforms a date into a Web Datestatic String
dat2WebTime
(Date date) Transforms a time as Date into a Web Timestatic String
dat2WebTimestamp
(Date dateTime) Transforms a date time into a Web Timestampstatic String
dat2WebTimestampMs
(Date date) Transforms a date into a Web Timestamp with millisecondsstatic String
dateSince
(Date date, AweElements elements) Retrieve how much time has elapsed since a datestatic String
elapsedTime
(Long milliseconds, AweElements elements) Retrieve how much time has elapsed from millisecondsstatic String
generic2Date
(String dateIn, String formatFrom, String formatTo) TransformColumn a date from a format to another date formatstatic Calendar
getCalendarDate
(String strSqlDate) Returns Calendar object for string Date with SQL formatstatic Date
getDateWithTimeFromCriteria
(String date, String time) Build java Date object from date criteria with Time criteriastatic String
Returns system date in SQL timestamp format (yyyy-MM-dd HH:mm:ss.SSS)static boolean
isJsonDate
(String date) Returns true if date is json datestatic boolean
Returns true if date is an SQL datestatic boolean
Returns true if date is an WBS datestatic boolean
Returns true if date is an WEB datestatic boolean
isWebTimestamp
(String date) Returns true if date is a Web timestampstatic boolean
isWebTimestampWithMs
(String date) Returns true if date is a Web date with millisecondsstatic Date
Transforms a JSON Date to a Date objectstatic String
Transforms a JSON Date from a Date objectstatic String
localDate2WebDate
(LocalDate localDate) Transforms a LocalDate into a Web datestatic String
localDatetime2WebTimestamp
(LocalDateTime localDateTime) Transforms a LocalDatetime into a Web Timestampstatic Date
Transforms a RDB String date into a java datestatic String
rdbDate2Web
(String date) Transforms an RDB date into a web date (23-OCT-1978)static String
sql2DateMs
(String val) Parse sql date to java date in millisecondsstatic Date
sql2JavaDate
(String timestamp) Transforms a SQL String date into a java datestatic String
sql2JsDate
(String date) Transforms a SQL String date into a js datestatic String
sql2JsTimestamp
(String date) Transforms a SQL String date into a js timestampstatic String
sql2WebDate
(String date) Transforms a SQL String date into a web datestatic String
sql2WebTime
(String timestamp) Transforms a SQL String date into a web timestatic String
sql2WebTimestamp
(String date) Transforms a SQL String date into a web timestampstatic String
sqlDat2JsDate
(Date date) Transforms a SQL String date into a web datestatic String
sqlDat2JsTimestamp
(Timestamp date) Transforms a SQL String date into a js timestampstatic String
sqlDat2WebDate
(Date date) Transforms a SQL String date into a web datestatic String
sqlDat2WebTime
(Time date) Transforms a SQL String date into a web timestatic String
sqlDat2WebTimestamp
(Timestamp date) Transforms a SQL String date into a web timestampstatic String
Transforms a SQL String date into a web timestamp with Millisecondsstatic Date
sqlDate2Date
(Date date) Transforms a sql date into a java Datestatic Date
sqlDate2JavaDate
(String date) Transforms a SQL String date (without time) into a java datestatic Date
sqlTimestamp2Date
(Timestamp timestamp) Transforms a sql timestamp into a java Datestatic Date
wbs2JavaDate
(String date) Transforms a WBS String date into a java datestatic String
wbs2JsDate
(String date) Transforms a web service date into a js datestatic String
wbs2WebDate
(String date) Transforms a web service date into a web datestatic Date
Transforms a web date (dd/MM/yyyy[ HH:mm:ss]) into a Date Return null if date is not validstatic String
web2RdbDate
(String date) Transforms a web date into an RDB date (23-OCT-1978)static Date
web2SqlDate
(String date) Transforms a web date into a SQL Datestatic Time
web2SqlTime
(String time) Transforms a web timestamp into a SQL Timestampstatic Timestamp
web2SqlTimestamp
(String timestamp) Transforms a web timestamp into a SQL Timestampstatic Date
Transforms a web time into a Date Return null if time is not validstatic Date
web2Timestamp
(String timestamp) Transforms a web timestamp into a Datestatic Date
web2TimestampWithMs
(String date) Transforms a web timestamp with ms into a Datestatic String
web2WbsDate
(String date) Transforms a web date into a web service datestatic Timestamp
webDate2SqlTimestamp
(String date) Transforms a web date into a SQL Timestamp
-
Field Details
-
DATE_FORMAT_WEB_PARSER
-
DATE_FORMAT_WEB
-
DATE_FORMAT_JS
-
DATE_FORMAT_SQL
-
DATE_FORMAT_WBS
-
DATE_FORMAT_RDB
-
TIMESTAMP_FORMAT_SQL_MS
-
TIMESTAMP_FORMAT_WEB
-
DATETIME_FORMAT_WEB
-
TIMESTAMP_FORMAT_JS
-
TIMESTAMP_FORMAT_WEB_MS
-
TIME_FORMAT_WEB
-
JSON_DATE
-
-
Method Details
-
web2SqlDate
Transforms a web date into a SQL Date- Parameters:
date
- Web Date- Returns:
- SQL Date
-
web2SqlTime
Transforms a web timestamp into a SQL Timestamp- Parameters:
time
- Web Timestamp- Returns:
- SQL Date
-
webDate2SqlTimestamp
Transforms a web date into a SQL Timestamp- Parameters:
date
- Web Date- Returns:
- SQL Timestamp
-
web2SqlTimestamp
Transforms a web timestamp into a SQL Timestamp- Parameters:
timestamp
- Web Timestamp- Returns:
- SQL Timestamp
-
web2Date
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
Transforms a web time into a Date Return null if time is not valid- Parameters:
time
- Web Time- Returns:
- SQL Date
-
web2Timestamp
Transforms a web timestamp into a Date- Parameters:
timestamp
- Web Timestamp date- Returns:
- timestamp Date
-
web2TimestampWithMs
Transforms a web timestamp with ms into a Date- Parameters:
date
- Web Date- Returns:
- SQL Date
-
dat2SqlDate
Transforms a date into a SQL Date- Parameters:
date
- Date- Returns:
- SQL Date
-
dat2SqlDateString
Transforms a date into a SQL Date- Parameters:
date
- Date- Returns:
- SQL Date
-
sqlTimestamp2Date
Transforms a sql timestamp into a java Date- Parameters:
timestamp
- Date- Returns:
- SQL Date
-
sqlDate2Date
Transforms a sql date into a java Date- Parameters:
date
- Date- Returns:
- SQL Date
-
dat2SqlTimestamp
Transforms a date into a SQL Time- Parameters:
date
- Date- Returns:
- SQL Timestamp
-
localDatetime2WebTimestamp
Transforms a LocalDatetime into a Web Timestamp- Parameters:
localDateTime
- Date- Returns:
- Web Timestamp
-
localDate2WebDate
Transforms a LocalDate into a Web date- Parameters:
localDate
- Date- Returns:
- Web Timestamp
-
dat2SqlTimeString
Transforms a timestamp date into a SQL Timestamp string- Parameters:
date
- Date- Returns:
- SQL Timestamp
-
dat2WebTimestamp
Transforms a date time into a Web Timestamp- Parameters:
dateTime
- Date- Returns:
- WEB Timestamp
-
dat2WebTimestampMs
Transforms a date into a Web Timestamp with milliseconds- Parameters:
date
- dateTime Date- Returns:
- WEB Timestamp
-
dat2WebTime
Transforms a time as Date into a Web Time- Parameters:
date
- Date- Returns:
- WEB Time
-
dat2WebDate
Transforms a date into a Web Date- Parameters:
date
- Date- Returns:
- String WEB date
-
dat2DateMs
Transforms a java Date into a date in milliseconds (Used in charts)- Parameters:
date
- Date- Returns:
- string date in milliseconds
-
sql2WebDate
Transforms a SQL String date into a web date- Parameters:
date
- SQL String Date- Returns:
- Web date formatted
-
sql2JavaDate
Transforms a SQL String date into a java date- Parameters:
timestamp
- SQL String Timestamp- Returns:
- Web date formatted
-
sqlDate2JavaDate
Transforms a SQL String date (without time) into a java date- Parameters:
date
- SQL String Date- Returns:
- Web date formatted
-
wbs2JavaDate
Transforms a WBS String date into a java date- Parameters:
date
- SQL String Date- Returns:
- Web date formatted
-
rdb2Date
Transforms a RDB String date into a java date- Parameters:
date
- SQL String Date- Returns:
- Web date formatted
-
sql2WebTime
Transforms a SQL String date into a web time- Parameters:
timestamp
- SQL String Date- Returns:
- Web time formatted
-
sql2WebTimestamp
Transforms a SQL String date into a web timestamp- Parameters:
date
- SQL String Date- Returns:
- Web timestamp formatted
-
sql2JsDate
Transforms a SQL String date into a js date- Parameters:
date
- SQL String Date- Returns:
- Web date formatted
-
sql2DateMs
Parse sql date to java date in milliseconds- Parameters:
val
- Sql date- Returns:
- Java date in milliseconds
-
sql2JsTimestamp
Transforms a SQL String date into a js timestamp- Parameters:
date
- SQL String Date- Returns:
- Web timestamp formatted
-
sqlDat2WebDate
Transforms a SQL String date into a web date- Parameters:
date
- SQL String Date- Returns:
- Web date formatted
-
sqlDat2WebTime
Transforms a SQL String date into a web time- Parameters:
date
- SQL String Date- Returns:
- Web time formatted
-
sqlDat2WebTimestamp
Transforms a SQL String date into a web timestamp- Parameters:
date
- SQL String Date- Returns:
- Web timestamp formatted
-
sqlDat2JsDate
Transforms a SQL String date into a web date- Parameters:
date
- SQL String Date- Returns:
- Web date formatted
-
sqlDat2JsTimestamp
Transforms a SQL String date into a js timestamp- Parameters:
date
- SQL String Date- Returns:
- Web timestamp formatted
-
dat2JsDate
Transforms a Date into a js date- Parameters:
date
- SQL String Date- Returns:
- Web timestamp formatted
-
dat2JsTimestamp
Transforms a Date into a js timestamp- Parameters:
date
- SQL String Date- Returns:
- Web timestamp formatted
-
sqlDat2WebTimestampWithMs
Transforms a SQL String date into a web timestamp with Milliseconds- Parameters:
date
- SQL String Date- Returns:
- Web timestamp formatted
-
web2WbsDate
Transforms a web date into a web service date- Parameters:
date
- (Web formatted)- Returns:
- Web Service date formatted
-
dat2WbsDate
Transforms a date into a web service date- Parameters:
date
- (Web formatted)- Returns:
- Web Service date formatted
-
web2RdbDate
Transforms a web date into an RDB date (23-OCT-1978)- Parameters:
date
- (Web formatted)- Returns:
- RDB date formatted
-
wbs2WebDate
Transforms a web service date into a web date- Parameters:
date
- (Web service formatted)- Returns:
- Web date formatted
-
wbs2JsDate
Transforms a web service date into a js date- Parameters:
date
- (Web service formatted)- Returns:
- Web date formatted
-
getSystemDate
Returns system date in SQL timestamp format (yyyy-MM-dd HH:mm:ss.SSS)- Returns:
- String SQL system date
-
getCalendarDate
Returns Calendar object for string Date with SQL format- Parameters:
strSqlDate
- SQL Date- Returns:
- Calendar object
-
isWebDate
Returns true if date is an WEB date- Parameters:
date
- (Web service formatted)- Returns:
- Is an WEB date
-
isWbsDate
Returns true if date is an WBS date- Parameters:
date
- (Web service formatted)- Returns:
- Is an WBS date
-
isSqlDate
Returns true if date is an SQL date- Parameters:
date
- (Web service formatted)- Returns:
- Is an SQL date
-
isWebTimestamp
Returns true if date is a Web timestamp- Parameters:
date
- (Web service formatted)- Returns:
- Is an WBS date
-
isWebTimestampWithMs
Returns true if date is a Web date with milliseconds- Parameters:
date
- (Web service formatted)- Returns:
- Is an WBS date
-
isJsonDate
Returns true if date is json date- Parameters:
date
- (Web service formatted)- Returns:
- Is an WBS date
-
jsonDate
Transforms a JSON Date to a Date object- Parameters:
date
- JSON date- Returns:
- Date OBJECT
-
jsonDate
Transforms a JSON Date from a Date object- Parameters:
date
- JSON date- Returns:
- Date OBJECT
-
getDateWithTimeFromCriteria
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
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
TransformColumn a date from a format to another date format- Parameters:
dateIn
- Input dateformatFrom
- Initial date formatformatTo
- Final date format- Returns:
- Date formatted
-
rdbDate2Web
Transforms an RDB date into a web date (23-OCT-1978)- Parameters:
date
- (Web formatted)- Returns:
- RDB date formatted
-
dat2RDBDate
Transforms Date into an RDB String (23-OCT-1978)- Parameters:
date
- (Web formatted)- Returns:
- RDB date formatted
-
elapsedTime
Retrieve how much time has elapsed from milliseconds- Parameters:
milliseconds
- Difference in millisecondselements
- AWE Elements- Returns:
- Date since
-
dateSince
Retrieve how much time has elapsed since a date- Parameters:
date
- Date to checkelements
- AWE Elements- Returns:
- Date since
-
autoDetectDateFormat
Autodetect date format and applies a format into java date- Parameters:
dateString
- String date- Returns:
- Date formatted
-
asLocalDate
CallsasLocalDate(Date, ZoneId)
with the system default time zone. -
asLocalDate
CreatesLocalDate
fromjava.util.Date
or it's subclasses. -
asLocalTime
CallsasLocalTime(Date, ZoneId)
with the system default time zone. -
asLocalTime
CreatesLocalTime
fromjava.util.Date
or it's subclasses. -
asLocalDateTime
CallsasLocalDateTime(Date, ZoneId)
with the system default time zone. -
asLocalDateTime
CreatesLocalDateTime
fromjava.util.Date
or it's subclasses. -
asUtilDate
CallsasUtilDate(Object, ZoneId)
with the system default time zone. -
asUtilDate
Creates aDate
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
Creates anInstant
fromjava.util.Date
or it's subclasses. Null-safe. -
asZonedDateTime
CallsasZonedDateTime(Date, ZoneId)
with the system default time zone. -
asZonedDateTime
CreatesZonedDateTime
fromjava.util.Date
or it's subclasses. Null-safe.
-