Java examples for java.sql:Timestamp
Converts a System.currentTimeMillis() into a Timestamp
//package com.java2s; import java.util.Calendar; public class Main { /**/*from w ww .ja va 2 s.com*/ * Converts a System.currentTimeMillis() into a Timestamp * @param now * @return */ public static java.sql.Timestamp toTimestamp(long now) { return new java.sql.Timestamp(now); } /** * Converts a date and time String into a Timestamp * * @param dateTime * A combined data and time string in the format * "MM/DD/YYYY HH:MM:SS", the seconds are optional * @return The corresponding Timestamp */ public static java.sql.Timestamp toTimestamp(String dateTime) { java.util.Date newDate = toDate(dateTime); if (newDate != null) return new java.sql.Timestamp(newDate.getTime()); else return null; } /** * Converts a date String and a time String into a Timestamp * * @param date * The date String: MM/DD/YYYY * @param time * The time String: either HH:MM or HH:MM:SS * @return A Timestamp made from the date and time Strings */ public static java.sql.Timestamp toTimestamp(String date, String time) { java.util.Date newDate = toDate(date, time); if (newDate != null) return new java.sql.Timestamp(newDate.getTime()); else return null; } /** * Makes a Timestamp from separate Strings for month, day, year, hour, * minute, and second. * * @param monthStr * The month String * @param dayStr * The day String * @param yearStr * The year String * @param hourStr * The hour String * @param minuteStr * The minute String * @param secondStr * The second String * @return A Timestamp made from separate Strings for month, day, year, * hour, minute, and second. */ public static java.sql.Timestamp toTimestamp(String monthStr, String dayStr, String yearStr, String hourStr, String minuteStr, String secondStr) { java.util.Date newDate = toDate(monthStr, dayStr, yearStr, hourStr, minuteStr, secondStr); if (newDate != null) return new java.sql.Timestamp(newDate.getTime()); else return null; } /** * Makes a Timestamp from separate ints for month, day, year, hour, minute, * and second. * * @param month * The month int * @param day * The day int * @param year * The year int * @param hour * The hour int * @param minute * The minute int * @param second * The second int * @return A Timestamp made from separate ints for month, day, year, hour, * minute, and second. */ public static java.sql.Timestamp toTimestamp(int month, int day, int year, int hour, int minute, int second) { java.util.Date newDate = toDate(month, day, year, hour, minute, second); if (newDate != null) return new java.sql.Timestamp(newDate.getTime()); else return null; } /** * Converts a date and time String into a Date * * @param dateTime * A combined data and time string in the format * "MM/DD/YYYY HH:MM:SS", the seconds are optional * @return The corresponding Date */ public static java.util.Date toDate(String dateTime) { // dateTime must have one space between the date and time... String date = dateTime.substring(0, dateTime.indexOf(" ")); String time = dateTime.substring(dateTime.indexOf(" ") + 1); return toDate(date, time); } /** * Converts a date String and a time String into a Date * * @param date * The date String: MM/DD/YYYY * @param time * The time String: either HH:MM or HH:MM:SS * @return A Date made from the date and time Strings */ public static java.util.Date toDate(String date, String time) { if (date == null || time == null) return null; String month; String day; String year; String hour; String minute; String second; int dateSlash1 = date.indexOf("/"); int dateSlash2 = date.lastIndexOf("/"); if (dateSlash1 <= 0 || dateSlash1 == dateSlash2) return null; int timeColon1 = time.indexOf(":"); int timeColon2 = time.lastIndexOf(":"); if (timeColon1 <= 0) return null; month = date.substring(0, dateSlash1); day = date.substring(dateSlash1 + 1, dateSlash2); year = date.substring(dateSlash2 + 1); hour = time.substring(0, timeColon1); if (timeColon1 == timeColon2) { minute = time.substring(timeColon1 + 1); second = "0"; } else { minute = time.substring(timeColon1 + 1, timeColon2); second = time.substring(timeColon2 + 1); } return toDate(month, day, year, hour, minute, second); } /** * Makes a Date from separate Strings for month, day, year, hour, minute, * and second. * * @param monthStr * The month String * @param dayStr * The day String * @param yearStr * The year String * @param hourStr * The hour String * @param minuteStr * The minute String * @param secondStr * The second String * @return A Date made from separate Strings for month, day, year, hour, * minute, and second. */ public static java.util.Date toDate(String monthStr, String dayStr, String yearStr, String hourStr, String minuteStr, String secondStr) { int month, day, year, hour, minute, second; try { month = Integer.parseInt(monthStr); day = Integer.parseInt(dayStr); year = Integer.parseInt(yearStr); hour = Integer.parseInt(hourStr); minute = Integer.parseInt(minuteStr); second = Integer.parseInt(secondStr); } catch (Exception e) { return null; } return toDate(month, day, year, hour, minute, second); } /** * Makes a Date from separate ints for month, day, year, hour, minute, and * second. * * @param month * The month int * @param day * The day int * @param year * The year int * @param hour * The hour int * @param minute * The minute int * @param second * The second int * @return A Date made from separate ints for month, day, year, hour, * minute, and second. */ public static java.util.Date toDate(int month, int day, int year, int hour, int minute, int second) { Calendar calendar = Calendar.getInstance(); try { calendar.set(year, month - 1, day, hour, minute, second); } catch (Exception e) { return null; } return new java.util.Date(calendar.getTime().getTime()); } }