Date format

Date format

Hi All,

I am getting a date from database as a format 2010-15-07.I need to change it to 07/15/2010 and display it on my date field.Every time i need to check the format of the date field and make sure the correct format and then display it.

How can i format it using java and also can we do it using javascript.

Thanks in advance..

puppy
View Answers

July 27, 2010 at 12:37 PM

Hi Friend,

Try the following code:

import java.sql.*;
import java.text.*;
import javax.swing.*;

public class GetDateFromDatabase {
public static void main(String args[]) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";;

String GET_RECORD = "select * from d where id='1'";
ResultSet rs = null;
Connection conn = null;
Statement stmt = null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url, "root", "root");

stmt = conn.createStatement();
rs = stmt.executeQuery(GET_RECORD);
String d="";
while (rs.next()) {
d = rs.getString("myDate");
}
int y=Integer.parseInt(d.substring(0,4))-1900;
int m=Integer.parseInt(d.substring(5,7))-1;
int da=Integer.parseInt(d.substring(8,10));
java.util.Date date=new java.util.Date(y,m,da);
SimpleDateFormat formatter = new SimpleDateFormat("MM/dd/yyyy");
System.out.println("Date : " + formatter.format(date));
JFrame f=new JFrame();
JPanel p=new JPanel();
p.add(new JLabel("Date is: "));
p.add(new JTextField(formatter.format(date)));
f.add(p);
f.setVisible(true);
f.pack();
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}

Thanks









Related Tutorials/Questions & Answers:
date format - Date Calendar
date format  how to convert dd-mmm-yyyy date format to gregorian calendar format in JSP please tell me the code  Hi friend, Code...="19-Sep-2008"; DateFormat format ; Date date ; format = new
Date format - Date Calendar
Date format  please convert dd-mmm-yy date format to gregorian calendar date format.  Hi friend, Code related your Problem: import...]); Calendar calendar = new GregorianCalendar(pdt); Date time = new Date
Advertisements
Date format - Date Calendar
Date format  Hi All, I am getting a date from database as a format 2010-15-07.I need to change it to 07/15/2010 and display it on my date field.Every time i need to check the format of the date field and make sure the correct
php date format change
php date format change  How to change the date format in PHP
convert current date into date format
convert current date into date format  How to get current date and convert into date format in Java or PHP
date_format()
date_format() date_format alias DateTime::format function returns date formatted according to given format. It returns formatted date on success otherwise False on failure. Description on date_format() PHP public string DateTime::format
php date format validation
php date format validation  How to validate the date field in specific format in PHP
String to date with no format
into a date .. this is simple .. but i want to do it without knowing the date format... date format can be (mm-dd-yyyy) if the 99th record also was 06-06-2006 the result should be date format can be (mm-dd-yyyy;dd-mm-yyyy) can sum1 please help me
select date in desired format
select date in desired format  how to select date from the database in DD/MM/YYYY format, because if i am trying select data from the database i am getting value in yyyy/mm/dd and time format like below "2012-05-07 00:00:00.0
java format date
java format date  Hi, How can I format the date in the following...) { Date date=new Date(); SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd"); String formattedDate=sdf.format(date
Date auto format
Date auto format  Hi, I have jsp page and Date field with input type. Requirement is, if we enter date as MMDDYY or MMDDYYYY and clicking the tab the date(MMDDYY or MMDDYYYY) have to auto format to MM/DD/YYYY. could you please
String to Date format
String to Date format  My Date format is String Eg(Jan 20 2011 ).... How to Change This values Like to database date format Eg(2011-01-20) using..."; Date date=new Date(d); SimpleDateFormat sdf=new
php date format am pm
php date format am pm  how to set the date format that will display the date in both am pm format
NSDateformatter format Date
NSDateformatter format Date  Hi, What is the correct way of writing NSDateFormatter in string format. Thanks.   For current Date in NSDate... that represent other data types. For example to show the date in string format we'll
date format in javascript
date format in javascript  display date format as dd/mm/yyyy and day... help me. thank u var date=/^\d{2}\/\d{2}\/\d{4}$/ if(document.userform.joindate.value.search(date)==-1) { alert("please enter date format as dd/mm/yyyy
Hibernate Date Format
This section contains description of Hibernate Date Format
date format - Java Beginners
date format  how to 45day in dd-mmm-yyyy date format.  Hi...-yyyy", Locale.US); Date d = sdf.parse(timestamp); Calendar cal..."; System.out.println("Date is : " + timestampToParse); Calendar cal = parseTimestamp
Date not getting in proper format
Date not getting in proper format  import java.util.*; class Date { public static void main(String[]args) { Date d = new Date(100000000000L); System.out.print("1st date"+d.toString()); } } out put:- 1st date@3e25
date format updated
date format updated  package LvFrm; import java.awt.Color; import... panel1,panel2,panel3,panel4; Font f1; JComboBox i1,j1,k1; JButton b1,b2; //for date...); panel2.setBorder(b2); frm.add(panel2); /*for date entry & adding
Mysql Date Format
Mysql Date Format       Mysql Date Format explains you the way of formatting Date... Date Format'. To understand this example we show you the following Syntax used
date format - Java Beginners
date format  How to convert yyyy-mm-dd to dd-mmm-yyyy  Hi... void main(String args[]) throws Exception{ Date todaysDate = new java.util.Date...-dd date is ==>"+formattedDate); Date date1 = formatter.parse
date format - JSP-Servlet
date format  how to convert 2008-10-14 to 14-Sep-2008   Hi..."; SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd"); Date dateStr...); System.out.println("yyyy-MM-dd date is ==>"+formattedDate); Date
Date Format required to change in java
Date Format required to change in java  can we change the format of date like sql as per our requirements???If yes then please give the detail solution
Change Date Format - Development process
Change Date Format   Hi, i hav used following line get date field from database . But my output is 2009/26/5. How to change the format
date_parse_from_format
  date_parse_from_format date_parse_from_format function returns... date_parse_from_format ( string $format , string $date ) Parameters of Date Parse Function PHP format - Format accepted by date() with some extras. date
Change Date Format - Development process
Change Date Format  Hi, While retrieving data frm database, date format displayed as yyyy/mm/dd but i want to display as dd/mm/yyyy. I have tried parse,format functions but not getting output. can u send me code
Simple Date Format Example
Following is a simple date format example made using Format class. We have uses a pattern of special characters to date and time format. In this example, SimpleDateFormat:class is used to format date into text and parse text into date
Sql Date and Time Format
Sql Date and Time Format     ...; is used to  format date and time.  SYNTAX:- DATE_FORMAT(date,format)ADS..._Format(date,format) Query return you the format date in the order of Week,Day
Formatting a Date Using a Custom Format
Formatting a Date Using a Custom Format In this section, you will learn how to format a date using a custom format. Java has provide many classes that allow a programmer to format the date and time. Here we have used SimpleDateFormat
php date format yyyy-mm-dd
php date format yyyy-mm-dd  date format yyyy-mm-dd validation
Date Format Example
Date Format Example       This example shows how to format Date using Format class. In this program we use a pattern of special characters to date and time format
Java Date Format Example
Java Date Format Example You can format date in many ways. In this tutorial Format class is used to format the java date in to the different formats... in the following ways. 1. Create an object of Format class. 2. Set The required date
struts2.2.1 date Format example
struts2.2.1 date Format example. In this example, We will discuss about the different type of date format using struts2.2.1. Directory structure of example...; <title>Date Format Example</title> </head>ADS_TO_REPLACE_2
date format to be updated with current date time
date format to be updated with current date time  package LvFrm...; JButton b1,b2; //for date month year entry String strD[]={"Day","1...); /*for date entry & adding date into panel 2 also addind panel
Mysql Date Format
Mysql Date Format      .... The Tutorial helps you to write the Date Format in SQL Query.  date_format...:- mysql> select date_format(now(),'%e %M %W %Y'); Output
ModuleNotFoundError: No module named 'date-format-machine'
ModuleNotFoundError: No module named 'date-format-machine'  Hi, My... named 'date-format-machine' How to remove the ModuleNotFoundError: No module named 'date-format-machine' error? Thanks   Hi
ModuleNotFoundError: No module named 'date-format-machine'
ModuleNotFoundError: No module named 'date-format-machine'  Hi, My... named 'date-format-machine' How to remove the ModuleNotFoundError: No module named 'date-format-machine' error? Thanks   Hi
Mysql Date Format codes
Mysql Date Format codes       The Tutorial illustrate an example from 'Mysql date format...; return you the date format in dd-mm-yy. mysql> select date_format
Regarding Date Format - Java Server Faces Questions
Regarding Date Format  How I can convert this(18-Aug-08) date format to Gregorian calendar date format?plz send me the syntax and code plz!!  hai,, http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f
c# current date in yyyy-MM-dd format
date in the format like 2021-01-12? I have to get the date into Year-Month-Date format. In c# how to get current date in yyyy-mm-dd format...(dateString ); Above code will give date into 2021-01-21 format (yyyy-MM-dd). I
Mysql Date Format Convert
Mysql Date Format Convert     ... and time. Now, we help you to convert the Mysql Date Format Conversion into other... an example 'Mysql Date Format Convert'. To grasp this concept we use Date now
Parsing a Date Using a Custom Format
Parsing a Date Using a Custom Format In this section, you will learn how to parse a date using a custom format. Java has provide many classes for handling date and time. Among them, SimpleDateFormat is easier to use for formatting
Java Date format - Java Server Faces Questions
Java Date format  Code to calculate days between two dates in format... dates in format(DD/MM/YYYY) import java.util.Date; import... static void main(String[] args) { //string containing date in one
Date format - Java Server Faces Questions
Date format  Hi All, I have field like Invoice Date is displaying a date like MMddyyyy HH:mm:ss format.i want to set format to MM//dd//yy. To set the format for the field, I believe you have to use the jsf
How to convert date to UTC format in Java?
How to convert date to UTC format in Java?  Hi, What is UTC Date format and How to convert date to UTC format in Java? I need simple to learn... representation and the String UTC to the date format. Thanks   Hi, Here
Simple Date Format Exception
Simple Date Format Exception       Simple Date Format Exception inherits from a package name... and normalization of date. Simple Date-format provides you to work on choosing any
validationrule for date as format yyyy-mm-dd in drools
validationrule for date as format yyyy-mm-dd in drools  Please give idea about this one..I have two textfield. User can select the date from... format yyyy-mm-dd: How i write the validation rule for date as a format yyyy-mm-dd
Date and Time Format Example
Date and Time Format Example       This Example shows you date and time format... method is used for format Date into date/time String. DateFormatExample.java
Jdatechooser : not able to fetch date in a specific format
at this website now i can't fetch date from it ina a specific format... but i am...Jdatechooser : not able to fetch date in a specific format  get date from Jdatechooser in format ddmmyyyy i am trying to use a component by KAI
PHP date_create_from_format function
date_create_from_format  function The date_create_from_format... according to the specified format. Parameters format Format accepted by date... DateTime object formatted according to the specified format.  Description

Ads