1. In JDBC, when to use Time, Date, and Timestamp stackoverflow.comJDBC offers me 3 different datatypes for time-related fields: "Date", "Time" and "Timestamp". Can someone provide a simple summary of what each one is used for and how to choose which ... |
2. Issue converting from java.util.Date to java.sql.Timestamp stackoverflow.comI'm trying to put a user provided date into an SQL database, and I have the following lines to process the string and convert it to a java.sql.Timestamp object. |
3. Playframework inserting wrong date in database stackoverflow.comI'm having a strage problem. In my form I'm using the jQuery datetime picker. This generates a string like |
4. How do i convert a Date object into a TimeStamp object coderanch.comHi! I got to store the current date and time in a Timestamp variable, i could retrieve the current date and time using Calendar cal = Calendar.getInstance(TimeZone.getDefault()); cal.getTime(); but the method of getTime() returns a date object where as i need a Timestamp object, now how do i convert a date object into a Timestamp object?? Please try and reply on ... |
5. Date, time and timestamp coderanch.comHi, I'm new to Java programming and I want to use date and time type for my database. I use MS Access as my database. Is there anyone have a complete program using date, time, or timestamp ? I can't understand if it's only a part of the program. Afterall, I'm really new. Thanks. |
6. On java.sql.Timestamp and java.sql.Date coderanch.com |
7. convert timestamp to date coderanch.com |
8. Date comparision in SQL from timestamp coderanch.comHow to compare a Timestamp returned from Java code 2004-06-11 00:00:01.0 in a query in Oracle to a date value 2004-06-11 00:00:00.0 in the table . I have used select id from table where TIME between to_date('2004-06-09 00:00:00','yyyy-mm-dd hh:mi:ss') and to_date('2004-06-11 00:00:00','yyyy-mm-dd hh:mi:ss') I get a message that hour can be between 1 and 12. But I want to check the ... |
9. link for DATE and TIMESTAMP coderanch.com |
10. Timestamp to date coderanch.comI am trying to figure out what a database field stands for,.... I have fields like 00000001153858800000, 0000009223372036854775807 etc., I thought this could be a timestamp and tried to get a date out of it This is the code I am using. When i put in 1153858800000L, it gives me Day: 2 Month:6 Year 2006 But when I enter 9223372036854775807, looks ... |
11. Julien Date and SQL TimeStamp conversions coderanch.comHi All, I need to convert the Julien date into gregorian which i could do but now i need to convert the SQL TimeStamp which is in nano seconds into the Normal TimeStamp i.e. hh:mm:ss.ssssssss These date and time stamp is coming straight out of mainframe which my Java programme has to convert into the normal format. I can also concatenate ... |
12. Julien Date and SQL TimeStamp conversions coderanch.comHi All, I need to convert the Julien date into gregorian which i could do but now i need to convert the SQL TimeStamp which is in nano seconds into the Normal TimeStamp i.e. hh:mm:ss.ssssssss These date and time stamp is coming straight out of mainframe which my Java programme has to convert into the normal format. I can also concatenate ... |
13. Converet from java.sql.Timestamp to java.util.Date coderanch.comOriginally posted by John Todd: Yes but Timestamp class contains the nano second part which java.util.Date doesn't handle it. When I'm trying to display the converted Date object (according to my previous posted code), I got: date info .. 00:00:00 ... Obviously, I lost the time. When you convert from timestamp to date, time will not be lost. the ... |
14. Date is there. Timestamp is not. coderanch.com |
15. java.util.date into java.sql.timestamp coderanch.comthanks ninad, t.setNanos(0) works. but the real problem is another thing: Is there a way to achieve this without using timestamps? I have only a date-instance and do define no nanos, so it should normally 0ns: Calendar a = Calendar.getInstance(); c.set(2010, 8, 1, 8, 0, 0); Date myDate= c.getTime(); but when representing this as a timestamp, then it shows me that ... |
16. Setting an sql.Date or Timestamp to time 0 => strange results forums.oracle.comThanks for your reply. It makes sense that a zero date is no valid date. Nonetheless I find it quite confusing to get that special date BC (e.g. 1.1.1 BC would have made more sense to me). But in my special case I have a use for this non-valid zero date. A MySql Timestamp supports as default the date 0000-00... Some ... |