java.sql.date to string

[Patrick Mallahan]

how would i convert a java.sql.date variable to a string?

[Paul Sturrock]

I recommend the toString() method of java.sql.Date class.

If you need to control the formatting, look at java.text.DateFormat and java.text.SimpleDateFormat.
[ July 11, 2005: Message edited by: Paul Sturrock ]

[Patrick Mallahan]

i used .toString() and it didnt seem to work. I am passing a string of the date formatted like yyyy-mm-dd to a class that converts the string to a java.sql.Date variable here is the snippet:

 setStartDate(java.sql.Date.valueOf(start)); 

Then I call getStarDate which consists of nothing but a return on the internal private variable and I am not getting anything in the return. It is coming abck null

[Steve Morrow]

What else is going on in setDate/getDate?

Example:

import java.sql.*;
 
public class Foo {
 
    private Date d;
 
    public static void main(String[] args) {
        Foo f = new Foo();
        f.setDate(Date.valueOf("2005-07-11"));
        System.out.println(f.getDate()); // 2005-07-11
    }    
    
    public void setDate(Date d) { this.d = d; }
    public Date getDate() { return d; }
 
} 

[Patrick Mallahan]

Set start/end date

 public void setStartDate(java.sql.Date value) { startDate=value; }
 
public void setEndDate(java.sql.Date value) { endDate=value; } 

get start/end date

 public java.sql.Date getStartDate() { return startDate; }
public java.sql.Date getEndDate() { return endDate; } 

[Steve Morrow]

There must be some other code that is interfering. Refer to the example I posted. If you still run into the problem, please post a short, concise, executable example of what you're trying to do. This does not have to be the actual code you are using. Write a small example that demonstrates your intent, and only that. Wrap the code in a class and give it a main method that runs it - if we can just copy and paste the code into a text file, compile it and run it without any changes, then we can be sure that we haven't made incorrect assumptions about how you are using it.