Date formatting

[bikkerss]

Hi i have the next problem i save a form with dates to a sqllite database
the dates are viewed by the users as "07 mei 2010" (dutch format) but i need to save it as an american format "2010-05-07" otherwise search functions on date in sql lite don't work wel

exp: "select date from questions where date between '1 mei 2010' and '7 mei 2010'

gives the complete database.

between 2 mei 2010 and '7 mei 2010' works as it should.

with american formatting this problem is solved but how can i convert the american formatting back to dutch ?

i use netbeans with formattedtextfields

[Fubarable]

Are you able to set your Locale to Dutch? If so, then SimpleDateFormat should work for you as it would then be able to translate a Dutch date to other formats easily.

[bikkerss]

That's the problem there's no Dutch in the locale list
so i don't know how to solve this (just a beginner)

if i look here http://java.sun.com/j2se/1.4.2/docs/...ocale.doc.html Dutch is provided but i don't see it in Netbeans
Can this help me with my problem ?

Are you able to set your Locale to Dutch? If so, then SimpleDateFormat should work for you as it would then be able to translate a Dutch date to other formats easily.

[Fubarable]

That's the problem there's no Dutch in the locale list
so i don't know how to solve this (just a beginner)

Sorry, I don't know, but don't give up hope as there are smarter folks, many from the Netherlands, who check this forum regularly.

Much luck!

[JosAH]

with american formatting this problem is solved but how can i convert the american formatting back to dutch ?

The Locale("nl") is fully supported.

kind regards,

Jos

[bikkerss]

how do i need to use this if i juse locale in netbeans i only seen canada till us but no dutch

[Fubarable]

What do you see if you run this?

import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Locale;

public class DutchDate {
  public static void main(String[] args) {
    Calendar today = Calendar.getInstance();
    System.out.println(today.getTime());
    
    Locale dutchLoc = new Locale("nl");
    SimpleDateFormat sdf = new SimpleDateFormat("EEEE, MMMM dd, yyyy", dutchLoc);
    System.out.println(sdf.format(today.getTime()));
    
  }
}

[JosAH]

how do i need to use this if i juse locale in netbeans i only seen canada till us but no dutch

Do you see the "nl" locale if you run this code snippet?

import java.util.Locale;

public class LLL {
	public static void main(String[] args) {

		Locale[] ls= Locale.getAvailableLocales();
		
		for (Locale l : ls)
			System.out.println(l);
	}
}

kind regards,

Jos

[bikkerss]

output:

Sat May 08 16:20:00 CEST 2010
zaterdag, mei 08, 2010

What do you see if you run this?

import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Locale;

public class DutchDate {
  public static void main(String[] args) {
    Calendar today = Calendar.getInstance();
    System.out.println(today.getTime());
    
    Locale dutchLoc = new Locale("nl");
    SimpleDateFormat sdf = new SimpleDateFormat("EEEE, MMMM dd, yyyy", dutchLoc);
    System.out.println(sdf.format(today.getTime()));
    
  }
}

[bikkerss]

are these al the options i can use instade of the "nl" option ?

output:

ja_JP
es_PE
en
ja_JP_JP
es_PA
sr_BA
mk
es_GT
ar_AE
no_NO
sq_AL
bg
ar_IQ
ar_YE
hu
pt_PT
el_CY
ar_QA
mk_MK
sv
de_CH
en_US
fi_FI
is
cs
en_MT
sl_SI
sk_SK
it
tr_TR
zh
th
ar_SA
no
en_GB
sr_CS
lt
ro
en_NZ
no_NO_NY
lt_LT
es_NI
nl
ga_IE
fr_BE
es_ES
ar_LB
ko
fr_CA
et_EE
ar_KW
sr_RS
es_US
es_MX
ar_SD
in_ID
ru
lv
es_UY
lv_LV
iw
pt_BR
ar_SY
hr
et
es_DO
fr_CH
hi_IN
es_VE
ar_BH
en_PH
ar_TN
fi
de_AT
es
nl_NL
es_EC
zh_TW
ar_JO
be
is_IS
es_CO
es_CR
es_CL
ar_EG
en_ZA
th_TH
el_GR
it_IT
ca
hu_HU
fr
en_IE
uk_UA
pl_PL
fr_LU
nl_BE
en_IN
ca_ES
ar_MA
es_BO
en_AU
sr
zh_SG
pt
uk
es_SV
ru_RU
ko_KR
vi
ar_DZ
vi_VN
sr_ME
sq
ar_LY
ar
zh_CN
be_BY
zh_HK
ja
iw_IL
bg_BG
in
mt_MT
es_PY
sl
fr_FR
cs_CZ
it_CH
ro_RO
es_PR
en_CA
de_DE
ga
de_LU
de
es_AR
sk
ms_MY
hr_HR
en_SG
da
mt
pl
ar_OM
tr
th_TH_TH
el
ms
sv_SE
da_DK
es_HN

Do you see the "nl" locale if you run this code snippet?

import java.util.Locale;

public class LLL {
	public static void main(String[] args) {

		Locale[] ls= Locale.getAvailableLocales();
		
		for (Locale l : ls)
			System.out.println(l);
	}
}

kind regards,

Jos

[bikkerss]

thanks i think i got it

[Fubarable]

You are getting nl_NL, so you're good.

[JosAH]

You are getting nl_NL, so you're good.

The "NL" part is a country code, there's also an "nl_BE" locale; it represents the flemisch language.

kind regards,

Jos

[Fubarable]

My latest take on this:

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Locale;

public class DutchDate {
  public static void main(String[] args) throws ParseException {
    String[] dutchDates = {
        "2 mei 2010",
        "7 mei 2010"
    };
    
    Locale dutchLoc = new Locale("nl", "NL");
    
    String nlFormatStr = "dd MMMM yyyy";
    String usFormatStr = "yyyy-MM-dd";
    
    SimpleDateFormat nlSdf = new SimpleDateFormat(nlFormatStr, dutchLoc);
    SimpleDateFormat usSdf = new SimpleDateFormat(usFormatStr, Locale.US);
    
    for (int i = 0; i < dutchDates.length; i++) {
      System.out.println("NL Date: " + dutchDates[i]);
      Date date = nlSdf.parse(dutchDates[i]);
      System.out.println("US Date: " + usSdf.format(date));
    }
    
    
  }
}