Java Code Examples for java.sql.Timestamp#after()
The following examples show how to use
java.sql.Timestamp#after() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: MessageServlet.java From mytwitter with Apache License 2.0 | 6 votes |
public void formatDate(Messageall messageall, Timestamp ttime) { SimpleDateFormat sdf = new SimpleDateFormat("MM-dd"); SimpleDateFormat sdf2 = new SimpleDateFormat("yy-MM-dd"); Calendar cal = Calendar.getInstance(); int year = cal.get(Calendar.YEAR); String nowyear = year + "-01-01 00:00:00"; Timestamp yeardate = Timestamp.valueOf(nowyear); if (ttime.after(yeardate)) { messageall.setTime(sdf.format(ttime)); } else { messageall.setTime(sdf2.format(ttime)); } }
Example 2
Source File: TechDataServices.java From scipio-erp with Apache License 2.0 | 6 votes |
/** Used to request the remaining capacity available for dateFrom in a TechDataCalenda, * If the dateFrom (param in) is not in an available TechDataCalendar period, the return value is zero. * * @param techDataCalendar The TechDataCalendar cover * @param dateFrom the date * @return long capacityRemaining */ public static long capacityRemainingBackward(GenericValue techDataCalendar, Timestamp dateFrom) { GenericValue techDataCalendarWeek = null; // TODO read TechDataCalendarExcWeek to manage exception week (maybe it's needed to refactor the entity definition try { techDataCalendarWeek = techDataCalendar.getRelatedOne("TechDataCalendarWeek", true); } catch (GenericEntityException e) { Debug.logError("Pb reading Calendar Week associated with calendar"+e.getMessage(), module); return 0; } // TODO read TechDataCalendarExcDay to manage execption day Calendar cDateTrav = Calendar.getInstance(); cDateTrav.setTime(dateFrom); Map<String, Object> position = dayEndCapacityAvailable(techDataCalendarWeek, cDateTrav.get(Calendar.DAY_OF_WEEK)); int moveDay = (Integer) position.get("moveDay"); if (moveDay != 0) return 0; Time startTime = (Time) position.get("startTime"); Double capacity = (Double) position.get("capacity"); Timestamp startAvailablePeriod = new Timestamp(UtilDateTime.getDayStart(dateFrom).getTime() + startTime.getTime() + cDateTrav.get(Calendar.ZONE_OFFSET) + cDateTrav.get(Calendar.DST_OFFSET)); if (dateFrom.before(startAvailablePeriod)) return 0; Timestamp endAvailablePeriod = new Timestamp(startAvailablePeriod.getTime()+capacity.longValue()); if (dateFrom.after(endAvailablePeriod)) return 0; return dateFrom.getTime() - startAvailablePeriod.getTime(); }
Example 3
Source File: TimeHandlingTest.java From gemfirexd-oss with Apache License 2.0 | 5 votes |
/** * Check the consistency of a ResultSet column that returns * CURRENT TIMESTAMP or a value set from CURRENT TIMESTAMP. * * @param start Time the statement settng the value was executed * @param end Time after first rs.next() or update statement was executed * @param rs ResultSet holding the column, positioned on a row * @param column Column with the timestamp. * @return Returns the Timestamp object obtained from the column. * @throws SQLException */ private Timestamp checkCurrentTimestampValue(long start, long end, ResultSet rs, int column) throws SQLException { Timestamp tsv = checkTimestampValue(rs, column); // The time returned should be between the value // of start and end (inclusive of both) Timestamp st = new Timestamp(start); Timestamp et = new Timestamp(end); if (st.after(et)) { // Gone back in time! // Well test was running around midnight and the // time for the start time is equal to or before 23:59:59 // and end time is equal to or after 00:00:00 assertTrue("CURRENT TIME outside of range when test crossing midnight", (tsv.equals(st) || tsv.after(st)) || (tsv.equals(et) || tsv.before(et))); } else { // End time is after or equal to start time, expected case. // The returned time must not be before the // start time or after the end time. assertFalse("CURRENT TIME before start of statement", tsv.before(st)); assertFalse("CURRENT TIME after end of statement", tsv.after(et)); } return tsv; }
Example 4
Source File: TimestampTimeModel.java From envelope with Apache License 2.0 | 5 votes |
@Override public int compare(Row first, Row second) { Timestamp ts1 = first.getAs(field.name()); Timestamp ts2 = second.getAs(field.name()); if (ts1.before(ts2)) { return -1; } else if (ts1.after(ts2)) { return 1; } else { return 0; } }
Example 5
Source File: ProductWorker.java From scipio-erp with Apache License 2.0 | 5 votes |
public static boolean isSellable(GenericValue product, Timestamp atTime) { if (product != null) { Timestamp introDate = product.getTimestamp("introductionDate"); Timestamp discDate = product.getTimestamp("salesDiscontinuationDate"); if (introDate == null || introDate.before(atTime)) { if (discDate == null || discDate.after(atTime)) { return true; } } } return false; }
Example 6
Source File: AsOfAttribute.java From reladomo with Apache License 2.0 | 5 votes |
public static boolean isMilestoningValid(Object obj, AsOfAttribute[] asOfAttributes) { for (AsOfAttribute asOfAttribute : asOfAttributes) { Timestamp from = asOfAttribute.getFromAttribute().valueOf(obj); Timestamp to = asOfAttribute.getToAttribute().valueOf(obj); if (from.equals(to) || from.after(to)) { return false; } } return true; }
Example 7
Source File: AsOfAttribute.java From reladomo with Apache License 2.0 | 5 votes |
public boolean asOfDateMatchesRange(Timestamp asOfDate, Timestamp from, Timestamp to) { if (asOfDate.equals(this.getInfinityDate())) { return to.equals(this.getInfinityDate()); } else { if (to.after(asOfDate) || (this.isToIsInclusive() && to.equals(asOfDate))) { return from.before(asOfDate) || (!this.isToIsInclusive() && from.equals(asOfDate)); } } return false; }
Example 8
Source File: LDCmisService.java From document-management-software with GNU Lesser General Public License v3.0 | 5 votes |
private Timestamp getLatestTimestamp(Timestamp date1, Timestamp date2) { if (date1 != null && date2 == null) return date1; if (date1 == null && date2 != null) return date2; if (date1.after(date2)) return date1; return date2; }
Example 9
Source File: EntitySyncContext.java From scipio-erp with Apache License 2.0 | 5 votes |
protected Timestamp getNextRunEndTime() { long syncSplit = this.isOfflineSync ? offlineSyncSplitMillis : syncSplitMillis; Timestamp nextRunEndTime = new Timestamp(this.currentRunStartTime.getTime() + syncSplit); if (nextRunEndTime.after(this.syncEndStamp)) { nextRunEndTime = this.syncEndStamp; } return nextRunEndTime; }
Example 10
Source File: UtilValidate.java From scipio-erp with Apache License 2.0 | 5 votes |
public static boolean isDateAfterNow(Timestamp date) { Timestamp now = UtilDateTime.nowTimestamp(); if (date != null) { return date.after(now); } return false; }
Example 11
Source File: TimestampTests.java From jdk8u60 with GNU General Public License v2.0 | 4 votes |
@Test(expectedExceptions = NullPointerException.class) public void test22() throws Exception { Timestamp ts1 = Timestamp.valueOf("1966-08-30 08:08:08"); ts1.after(null); }
Example 12
Source File: AddDateAware.java From ApprovalTests.Java with Apache License 2.0 | 4 votes |
public boolean isExtracted(AddDateAware object) throws IllegalArgumentException { ObjectUtils.assertInstance(AddDateAware.class, object); Timestamp addDate = ((AddDateAware) object).getAddDate(); return (addDate == null) ? false : !addDate.after(date); }
Example 13
Source File: TimestampTest.java From openjdk-jdk9 with GNU General Public License v2.0 | 4 votes |
/** * Compares two Timestamps with the expected result. * * @param ts1 the first Timestamp * @param ts2 the second Timestamp * @param expect the expected relation between ts1 and ts2; 0 if * ts1 equals to ts2, or 1 if ts1 is after ts2, or -1 if ts1 is * before ts2. */ private void compareTimestamps(Timestamp ts1, Timestamp ts2, int expected) { boolean expectedResult = expected > 0; boolean result = ts1.after(ts2); if (result != expectedResult) { errln("ts1.after(ts2) returned " + result + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } expectedResult = expected < 0; result = ts1.before(ts2); if (result != expectedResult) { errln("ts1.before(ts2) returned " + result + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } expectedResult = expected == 0; result = ts1.equals(ts2); if (result != expectedResult) { errln("ts1.equals(ts2) returned " + result + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } int x = ts1.compareTo(ts2); int y = (x > 0) ? 1 : (x < 0) ? -1 : 0; if (y != expected) { errln("ts1.compareTo(ts2) returned " + x + ", expected " + relation(expected, "") + "0" + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } long t1 = ts1.getTime(); long t2 = ts2.getTime(); int z = (t1 > t2) ? 1 : (t1 < t2) ? -1 : 0; if (z == 0) { int n1 = ts1.getNanos(); int n2 = ts2.getNanos(); z = (n1 > n2) ? 1 : (n1 < n2) ? -1 : 0; } if (z != expected) { errln("ts1.getTime() " + relation(z, "==") + " ts2.getTime(), expected " + relation(expected, "==") + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } }
Example 14
Source File: TimestampTests.java From jdk8u-jdk with GNU General Public License v2.0 | 4 votes |
@Test(expectedExceptions = NullPointerException.class) public void test22() throws Exception { Timestamp ts1 = Timestamp.valueOf("1966-08-30 08:08:08"); ts1.after(null); }
Example 15
Source File: TweetServletTwo.java From mytwitter with Apache License 2.0 | 4 votes |
public String roll(List<Utweets> tweetsList, int uid) { JSONArray js = new JSONArray(); for (Utweets utweets : tweetsList) { if (utweets.getTzhuan() > 0) { Forwards forward = forwardsDao.getForward(utweets.getTid(), utweets.getTtime()); int id = forward.getStid(); Utweets utweet = tweetsDao.getTweetsByTid(id); utweets.setUtweets(utweet); } int tid = utweets.getTid(); boolean zhuaned = forwardsDao.selForward(uid, tid); if (zhuaned == true) utweets.setZhuaned(1); else utweets.setZhuaned(0); boolean zaned = likesDao.selLike(uid, tid); if (zaned == true) utweets.setZaned(1); else utweets.setZaned(0); Timestamp ttime = utweets.getTtime(); SimpleDateFormat sdf = new SimpleDateFormat("MM月dd日 HH:mm"); SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy年MM月dd日 HH:mm"); SimpleDateFormat sdf3 = new SimpleDateFormat("HH:mm"); Calendar cal = Calendar.getInstance(); int day = cal.get(Calendar.DATE); int month = cal.get(Calendar.MONTH) + 1; int year = cal.get(Calendar.YEAR); String nowyear = year + "-01-01 00:00:00"; Timestamp yeardate = Timestamp.valueOf(nowyear); String nowday = year + "-" + month + "-" + day + " 00:00:00"; Timestamp date = Timestamp.valueOf(nowday); // 此处转换为毫秒数 long millionSeconds = ttime.getTime();// 毫秒 long nowSeconds = System.currentTimeMillis(); long chazhi = nowSeconds - millionSeconds; if (chazhi < 60000) { utweets.setTime("现在"); } else if (chazhi < 3600000) { long n = chazhi / 60000; utweets.setTime(n + "分钟"); } else if (ttime.after(date)) { utweets.setTime(sdf3.format(ttime)); } else if (ttime.after(yeardate)) { utweets.setTime(sdf.format(ttime)); } else { utweets.setTime(sdf2.format(ttime)); } js.add(getJsonObj(utweets.getTid(), utweets.getUid(), utweets.getTcontent(), utweets.getTpic(), utweets.getTvideo(), utweets.getTreply(), utweets.getTforward(), utweets.getTlike(), utweets.getUname(), utweets.getUpwd(), utweets.getUrealname(), utweets.getUaite(), utweets.getUonline(), utweets.getUabout(), utweets.getUlogo(), utweets.getUbg(), utweets.getUfans(), utweets.getUtweet(), utweets.getUfollow(), utweets.getUcolor(), utweets.getTime(), utweets.getUtweets(), utweets.getTzhuan(), utweets.getZaned(), utweets.getZhuaned())); } return js.toString(); }
Example 16
Source File: TimestampTest.java From TencentKona-8 with GNU General Public License v2.0 | 4 votes |
/** * Compares two Timestamps with the expected result. * * @param ts1 the first Timestamp * @param ts2 the second Timestamp * @param expect the expected relation between ts1 and ts2; 0 if * ts1 equals to ts2, or 1 if ts1 is after ts2, or -1 if ts1 is * before ts2. */ private void compareTimestamps(Timestamp ts1, Timestamp ts2, int expected) { boolean expectedResult = expected > 0; boolean result = ts1.after(ts2); if (result != expectedResult) { errln("ts1.after(ts2) returned " + result + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } expectedResult = expected < 0; result = ts1.before(ts2); if (result != expectedResult) { errln("ts1.before(ts2) returned " + result + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } expectedResult = expected == 0; result = ts1.equals(ts2); if (result != expectedResult) { errln("ts1.equals(ts2) returned " + result + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } int x = ts1.compareTo(ts2); int y = (x > 0) ? 1 : (x < 0) ? -1 : 0; if (y != expected) { errln("ts1.compareTo(ts2) returned " + x + ", expected " + relation(expected, "") + "0" + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } long t1 = ts1.getTime(); long t2 = ts2.getTime(); int z = (t1 > t2) ? 1 : (t1 < t2) ? -1 : 0; if (z == 0) { int n1 = ts1.getNanos(); int n2 = ts2.getNanos(); z = (n1 > n2) ? 1 : (n1 < n2) ? -1 : 0; } if (z != expected) { errln("ts1.getTime() " + relation(z, "==") + " ts2.getTime(), expected " + relation(expected, "==") + ". (ts1=" + ts1 + ", ts2=" + ts2 + ")"); } }
Example 17
Source File: ReplyServlet.java From mytwitter with Apache License 2.0 | 4 votes |
@Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { req.setCharacterEncoding("UTF-8"); resp.setContentType("text/html;charset=UTF-8"); String page = req.getParameter("page"); String tid = req.getParameter("tid"); List<Replyall> replys = replysDao.getAllReply(Integer.parseInt(tid), Integer.parseInt(page)); if (replys == null) { return; } JSONArray js = new JSONArray(); for (Replyall reply : replys) { Timestamp rtime = reply.getRtime(); SimpleDateFormat sdf = new SimpleDateFormat("MM月dd日 HH:mm"); SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy年MM月dd日 HH:mm"); SimpleDateFormat sdf3 = new SimpleDateFormat("HH:mm"); Calendar cal = Calendar.getInstance(); int day = cal.get(Calendar.DATE); int month = cal.get(Calendar.MONTH) + 1; int year = cal.get(Calendar.YEAR); String nowyear = year + "-01-01 00:00:00"; Timestamp yeardate = Timestamp.valueOf(nowyear); String nowday = year + "-" + month + "-" + day + " 00:00:00"; Timestamp date = Timestamp.valueOf(nowday); // 此处转换为毫秒数 long millionSeconds = rtime.getTime();// 毫秒 long nowSeconds = System.currentTimeMillis(); long chazhi = nowSeconds - millionSeconds; if (chazhi < 60000) { reply.setTime("现在"); } else if (chazhi < 3600000) { long n = chazhi / 60000; reply.setTime(n + "分钟"); } else if (rtime.after(date)) { reply.setTime(sdf3.format(rtime)); } else if (rtime.after(yeardate)) { reply.setTime(sdf.format(rtime)); } else { reply.setTime(sdf2.format(rtime)); } js.add(getJsonObj(reply.getRid(), reply.getUid(), reply.getTid(), reply.getRcontent(), reply.getTime(), reply.getUname(), reply.getUrealname(), reply.getUaite(), reply.getUlogo())); } resp.getWriter().print(js.toString()); }
Example 18
Source File: TimestampTests.java From hottub with GNU General Public License v2.0 | 4 votes |
@Test(expectedExceptions = NullPointerException.class) public void test22() throws Exception { Timestamp ts1 = Timestamp.valueOf("1966-08-30 08:08:08"); ts1.after(null); }
Example 19
Source File: TimestampTests.java From jdk8u_jdk with GNU General Public License v2.0 | 4 votes |
@Test(expectedExceptions = NullPointerException.class) public void test22() throws Exception { Timestamp ts1 = Timestamp.valueOf("1966-08-30 08:08:08"); ts1.after(null); }
Example 20
Source File: TechDataServices.java From scipio-erp with Apache License 2.0 | 4 votes |
/** * * Used to check if there is not two routing task with the same SeqId valid at the same period * * @param ctx The DispatchContext that this service is operating in. * @param context a map containing workEffortIdFrom (routing) and SeqId, fromDate thruDate * @return result a map containing sequenceNumNotOk which is equal to "Y" if it's not Ok */ public static Map<String, Object> checkRoutingTaskAssoc(DispatchContext ctx, Map<String, ? extends Object> context) { Delegator delegator = ctx.getDelegator(); Map<String, Object> result = new HashMap<String, Object>(); String sequenceNumNotOk = "N"; Locale locale = (Locale) context.get("locale"); String workEffortIdFrom = (String) context.get("workEffortIdFrom"); String workEffortIdTo = (String) context.get("workEffortIdTo"); String workEffortAssocTypeId = (String) context.get("workEffortAssocTypeId"); Long sequenceNum = (Long) context.get("sequenceNum"); Timestamp fromDate = (Timestamp) context.get("fromDate"); Timestamp thruDate = (Timestamp) context.get("thruDate"); String create = (String) context.get("create"); boolean createProcess = (create !=null && "Y".equals(create)) ? true : false; List<GenericValue> listRoutingTaskAssoc = null; try { listRoutingTaskAssoc = EntityQuery.use(delegator).from("WorkEffortAssoc") .where("workEffortIdFrom", workEffortIdFrom,"sequenceNum",sequenceNum) .orderBy("fromDate") .queryList(); } catch (GenericEntityException e) { Debug.logWarning(e, module); return ServiceUtil.returnError(UtilProperties.getMessage(resource, "ManufacturingTechDataWorkEffortAssocNotExist", UtilMisc.toMap("errorString", e.toString()), locale)); } if (listRoutingTaskAssoc != null) { for (GenericValue routingTaskAssoc : listRoutingTaskAssoc) { if (! workEffortIdFrom.equals(routingTaskAssoc.getString("workEffortIdFrom")) || ! workEffortIdTo.equals(routingTaskAssoc.getString("workEffortIdTo")) || ! workEffortAssocTypeId.equals(routingTaskAssoc.getString("workEffortAssocTypeId")) || ! sequenceNum.equals(routingTaskAssoc.getLong("sequenceNum")) ) { if (routingTaskAssoc.getTimestamp("thruDate") == null && routingTaskAssoc.getTimestamp("fromDate") == null) sequenceNumNotOk = "Y"; else if (routingTaskAssoc.getTimestamp("thruDate") == null) { if (thruDate == null) sequenceNumNotOk = "Y"; else if (thruDate.after(routingTaskAssoc.getTimestamp("fromDate"))) sequenceNumNotOk = "Y"; } else if (routingTaskAssoc.getTimestamp("fromDate") == null) { if (fromDate == null) sequenceNumNotOk = "Y"; else if (fromDate.before(routingTaskAssoc.getTimestamp("thruDate"))) sequenceNumNotOk = "Y"; } else if (fromDate == null && thruDate == null) sequenceNumNotOk = "Y"; else if (thruDate == null) { if (fromDate.before(routingTaskAssoc.getTimestamp("thruDate"))) sequenceNumNotOk = "Y"; } else if (fromDate == null) { if (thruDate.after(routingTaskAssoc.getTimestamp("fromDate"))) sequenceNumNotOk = "Y"; } else if (routingTaskAssoc.getTimestamp("fromDate").before(thruDate) && fromDate.before(routingTaskAssoc.getTimestamp("thruDate"))) sequenceNumNotOk = "Y"; } else if (createProcess) sequenceNumNotOk = "Y"; } } result.put("sequenceNumNotOk", sequenceNumNotOk); return result; }