1. Performing Date/Time Math In HQL? stackoverflow.comI'm looking how to perform date/time math within an HQL query. Specifically, how do I add or subtract (x) amount of time from the result of the |
2. datetime and timespan arithmetic in TSQL via HQL stackoverflow.comI need to create an HQL where clause which has the form: |
3. Java type for date/time when using Oracle Date with Hibernate stackoverflow.comWe have a Oracle Date column. At first in our Java/Hibernate class we were using |
4. How to store Java Date to Mysql datetime...? stackoverflow.comCan any body tell me how can i store Java Date to Mysql datetime...? When I am trying to do so...only date is stored and time remain 00:00:00 in mysql date stores like ... |
5. Java: JPA classes, refactoring from Date to DateTime stackoverflow.comWith a table created using this SQL |
6. MySQL Datetime <-> Java Date stackoverflow.comI use Hibernate and I have a datetime in my MySQL database. Now I want to store the date/time which is a java.util.Date into the database. So I can write: |
7. Compare datetime property to certain date via HQL (.Net) stackoverflow.comI have problems comparing the datetime property of objects and when trying to compare to a given date. For example, I tried |
8. Hibernate save to db 31.12.2009 23:00:00.000000 instead of 1.1.2010 stackoverflow.comI have application with spring + jpa + hibernate. There are two joda date time fields. They are generate to database as TimeStamp(6). The first one is set to DateTime() The second one ... |
9. Storing joda-time datetime in database stackoverflow.comMy application already uses Joda-time for date manipulation with plans to upgrade to jsr 310 in the near future. Now I need to store VERY accurate timestamp in the database using jpa ... |
10. JPA 2.0 and Oracle with TemporalType.TIME stackoverflow.comI'm Using Oracle 11g and JPA 2.0 (hibernate in JBoss 6.0.0). I need to represent a time range in an entity, so I defined those fields: |
11. How to get sysdate, time and timestamp from database using hibernate stackoverflow.comIn my application I need to get database date( |
12. JPA, Glassfish, Mysql: UTC time conversion occuring twice stackoverflow.comI'm going nuts here... I have recently noticed that time is mis-presented in my JPA-managed entities, when I access a
|
13. Hibernate: On SQL Server 2008 column was altered from datetime to datetime2. How I can update hibernate config to reflect this? stackoverflow.comI have an application in which I created mappings of entities in Hibernate, so I could have access to some legacy tables on SQL Server 2005. Everything was working fine and ... |
14. Compare Date Java to DateTime Column in database table using SQL stackoverflow.comI've got two |
15. Hibernate datetime coderanch.comhello everbody i have used hibernate3.2 + JSF1.2+ MsSql 2005 i have table that one column type datetime and checked allows null value. one persist object correspond that column public String getWorkdate() { return workdate; } public void setWorkdate(String murcth) { this.workdate = workdate; } if i not insert value in this columns that otomatically get like this value 1/1/1900 12:00:00 ... |
16. Why does JPA change a datetime value from "0000-00-00 00:00:00" to null? coderanch.comHi, I have a NOT NULL datetime column DATEAUTHORIZATION in a MySQL table. The records have the value "0000-00-00 00:00:00" in this field. I'm using JPA in my application, but when I read this datetime field, JPA changes it to null. If I want just update any other field (and not DATEAUTHORIZATION ) it raises an error complaining that the datetime ... |
17. How to insert DateTime with HQL coderanch.comParameter binding didn't work. I ve read that parameters binding only works in where clause. I 've tried this Query query = session.createQuery(insert into A (name,date1) select p.name,:myDate from person p ) .setParameter("myDate",myCorrectDate); When HQL Parser tries to parse that, it shows me org.hibernate.QueryException: number of select types did not match those for insert at org.hibernate.hql.ast.tree.IntoClause.validateTypes(IntoClause.java:115) at org.hibernate.hql.ast.tree.InsertStatement.validate(InsertStatement.java:57) at org.hibernate.hql.ast.HqlSqlWalker.postProcessInsert(HqlSqlWalker.java:714) at ... |
18. Hibernate using datetime2 with SQLServer2005 instead of datetime coderanch.com |
19. Hibernate+MySQL+DateTime forum.hibernate.orgI have a table in Mysql with a column of type datetime. If this column is null or it is "0000-00-00 00:00:00", it make a exception for sql gramatic. If this column have a good date, it have not exceptions. I have tried with type date and timestamp on "hbm.xml". How can i resolve it? |
20. Datetime type on SQL Server losting its time information forum.hibernate.orgHi All, I am seeing some strange behavior on SQL Server where, when I drop a row into a hibernate-managed table, a column of type "date" is being persisted incorrectly. The date information is being stored fine (year, month, and day), but the time information is being lost. I tried adding a column tag with sql-type="datetime", but that is giving me ... |
21. DateTime forum.hibernate.orgWhen I have a DateTime field in a database do I have to use the Calendar type in my hibernate objects/mappings to retrieve the date and time. At the moment I am just using java.util.Date which, when persisting, will eat the time component and leave the date only. Should I be using a Calendar type for datetimes or am I doing ... |
22. Problem with DateTime forum.hibernate.orgHi Again, I have a mapping which is as follows: Code: |
23. Database current DateTime forum.hibernate.org |
24. MySQL Datetime vs. Timestamp forum.hibernate.orgThanks in advance for the help. I'm using Hibernate 2.1 with MySQL 4.1 and I'm having a problem with losing precision when trying to store a java.util.Calendar object. Theorectically, I should be able to maintain precision if it's stored as a SQL Timestamp. However, when Hibernate creates the tables, a sql datetime is used instead. Looking at the MySQL Dialect, this ... |
25. MySQL DATETIME column named 'timestamp" forum.hibernate.orgAuthor Message rhombz Post subject: MySQL DATETIME column named 'timestamp" Posted: Thu Dec 08, 2005 1:22 am Newbie Joined: Thu Dec 08, 2005 12:04 am Posts: 2 Location: Melbourne, Australia Hibernate version: 2.0 Mapping documents: Code: |
26. What annotation for sql-type="datetime" forum.hibernate.org |
27. Problems with datetime using createSql() forum.hibernate.orgIm trying to do a query that recieves visitors from a table between 2 dates. However, Im getting an error saying: Caused by: java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. I understand the fact that it says its caused by java.sql.SQLException, but here are the strange parts. This is the day format that im trying to ... |
28. timestamp to datetime conversion exception in SQL server2005 forum.hibernate.orgHi, I'm trying to persist a field "entertimestamp" that is of type java.sql.Timestamp to a column "enter_TS", a datetime datatype in sql server 2005. I get an exception : java.lang.UnsupportedOperationException: cannot perform lookups on timestamps. I don't know if I can do the conversion with the primary key since enter_TS is a part of the key. Hibernate version: 3.0 Mapping documents: ... |
29. string representation of a datetime value is incorrect forum.hibernate.orgI have a composite key, of which there is a timestamp value as one of them. However, hibernate gives the error: cannot perform look up's for timestamps. Hence, i changed the datatype of the timestamp to string and am able to persist the column. However, the same thing is not working for my colleague, the reason being he is using an ... |
30. what is the result of avg(datetime)? forum.hibernate.orgI use avg() function to calculate the average time for some selected rows, using something like: 'avg(t.datetime1 - t.datetime2)' Since MySql is in behind, the returned result is in 'military' format, e.g. for average time of 3 min and 5 sec, the result is : 305. I also know that other databases (Oracle) does not return the avg of datetime in ... |
31. How to get "Day of week" from DateTime in HQL? forum.hibernate.orgHi, I am facing a problem using Hibernate. I am using MS SQL 2000. I am retrivng some data using HQL. In this data there is a field of data type DataTime. When I retrive data of this field I get date like: |
32. Problem with datetime-difference in hibernate forum.hibernate.orgHello, I have recognized a strange problem: The application runs on tomcat5.5 with spring1.2, hibernate3 and the DB is mysql 5. The datetimes in mysql are ok. (I have checked with unix_timestamp()!) Sometimes the datetime-value in Hibernate (in java.util.Date) is one hour after the datetime-value in mysql. This effect occurs, if, - The systemclock goes wrong (behind actual time, 5 seconds ... |
33. How use 'datetime' type in oracle? forum.hibernate.org |
34. comparison against MySql datetime forum.hibernate.org |
35. Using DB NOW() rather than DateTime.Now forum.hibernate.orgHi, Is there a way to set the value of an SQL DateTime column to NOW() from within the NHibernate model? I understand that it'd be a special case but it seems like a sensible one. I suppose one alternative is to use a timestamp type with default current_timestamp and set the value to NULL before persisting. Steve |
36. update datetime and timestamp column forum.hibernate.orgBasically, I am trying to map a table like below, created_on datetime not null default current_timestamp, modified_on timestamp not null default current_timestamp, Here is my code, @Column(name="modified_on", updatable=false, insertable=false, columnDefinition="timestamp not null default current_timestamp") @org.hibernate.annotations.Generated(org.hibernate.annotations.GenerationTime.ALWAYS) private Date modifiedOn; @Column(name="created_on", updatable=false, insertable=false, columnDefinition="datetime not null default current_timestamp") @org.hibernate.annotations.Generated(org.hibernate.annotations.GenerationTime.INSERT) private Date createdOn; I want these two column would be updated automatically, during insert, ... |
37. Which Date class to use with mysql datetime forum.hibernate.org |
38. Timestamp to datetime forum.hibernate.orgHi, I'm trying to save a field of type java.sql.Timestamp to a column of type datetime in sql server 2005. But the value saved in db is not having time value. For example if i send a timestamp value : "2008-10-14 16:37:02.862" to save, the value saved in db is "2008-10-14 00:00:00.000". Pls help. |
39. Mysql Datetime inconsistency forum.hibernate.orgI'm using Hibernate and MySQL and I'm having an inconsistency problem related to storing, retrieving and comparing dates. I have a table called ProfileVisit which has a date field. The hibernate mapping is: |