Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Save date without time

Posted on 2014-01-13
15
494 Views
Last Modified: 2014-01-16
Hello there,

I have this method which converts Persian date to gregoian date and saves in the mssql db. the data is now saved like this in the table col 2014-01-14 00:00:00.
How can I save the date without the time i.e. I just want to save this 2014-01-14

@SuppressWarnings("deprecation")
	public static Date jalaliToGregorian(String nowDate) {
		try{
			GWTPersianCalendar pcal1 = new GWTPersianCalendar();
			pcal1.parsePersianDate(nowDate);
			return new Date(pcal1.getTime());
			
		}
		catch (Exception e) {
			return new Date(nowDate);
		}
		
	}

Open in new window


cheers
Zolf
0
Comment
Question by:zolf
  • 6
  • 4
  • 2
  • +2
15 Comments
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 100 total points
ID: 39775922
You would have to make a DATE column.  DATETIME column will always add the 00:00:00.

MySQL or Microsoft SQL Server?
0
 

Author Comment

by:zolf
ID: 39775930
thanks for your feedback.

I am using Microsoft SQL Server 2008
0
 

Author Comment

by:zolf
ID: 39775937
this is my hibernate hbm file

<property name="mfgDate" type="java.util.Date">
            <column name="mfgDate" />
        </property>
        <property name="expDate" type="java.util.Date">
            <column name="expDate" />
        </property>

Open in new window

0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39775948
Here http://technet.microsoft.com/en-us/library/ms186724.aspx are the date and time datatypes available in Microsoft SQL Server.  "hibernate hbm file" means nothing to me and it does not look like it is what defines the columns in an SQL Server Database.  Is it 'your' database so you can have the columns re-defined?
0
 

Author Comment

by:zolf
ID: 39775991
I am using hibernate to create the tables for me in the database
0
 
LVL 86

Assisted Solution

by:CEHJ
CEHJ earned 100 total points
ID: 39776157
this is my hibernate hbm file
Well if you used java.sql.Date instead, then that doesn't hold time info. It still might be better simply to truncate or ingore time info though
0
 

Author Comment

by:zolf
ID: 39776186
thanks for your comment.

can you please elaborate on this
It still might be better simply to truncate or ingore time info though
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 39776229
It's better to have too much information (which is discardable - just don't manifest it in the presentation layer) than not enough
0
 
LVL 32

Expert Comment

by:awking00
ID: 39777535
It looks like you are using the method getTime() from the GWTPersianCalendar class to return your conversion value. What datatype is that and what other methods might it have (such as getDate)?
0
 

Author Comment

by:zolf
ID: 39778366
by: awking00

thanks for your feedback. this is the getTime() method of GWTPersianCalendar class.that is the only method it has.

@Override
    public long getTime() {
        // TODO Remove timeZoneoffset like /*- (getTimezoneOffset()*60000) */
        return super.getTime();
    }
0
 
LVL 1

Assisted Solution

by:Smart_Kid
Smart_Kid earned 300 total points
ID: 39784949
Change the datatype of your column in database to DATE  (i preassume, the current datatype will be DATETIME).
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 39785058
Change the datatype of your column in database to DATE  
Why would you want to lose information for a negligible saving in storage?
0
 
LVL 1

Accepted Solution

by:
Smart_Kid earned 300 total points
ID: 39785082
Changing the datatype was not mentioned not to save any storage space.
But it was a possible suggestion/answer to the question.

The question is that the programmer is not interested in saving the date in database with the time info. As per the question, not even 00:00:00 should not be saved in the database. So the only option for storing just date is to change the datatype of the column.

Kindly go through the question once again.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 39785112
Kindly go through the question once again.
I don't need to ;)
0
 

Author Closing Comment

by:zolf
ID: 39787633
Thanks
0

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Spring Framework HTTPSession management 1 45
java jdbc batch example 8 41
eclipse with Angularjs2.0 3 57
Selenium docs api java index 3 48
Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question