Formatting Dates and Times

Question

0.00/5 (No votes)

See more:

Am I really that stupid? [no don't answer]

I want to format dates and times to LOCALE format, so a UK machine would show 30/07/2012 and 1,234.56, an American 07/30/2012 and 1,234.56, and a Hungarian 2012.07.30. and 1 234,56.

The date is simple:

JavaScript

var dateSting = new Date(2012,07,30,0,0,0).toLocaleDateString(); // or something

Now, is there an easy, quick and RELIABLE way to format a number to the local style?

** EDIT **

Me bad! I want to format a NUMBER, the date part is okay.

Posted 29-Jul-12 19:49pm

Nagy Vilmos

Updated 30-Jul-12 0:11am

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Answer 1 · 2012-07-29T20:06:00

Solution 1

toLocaleString[^]

you were close.

Posted 29-Jul-12 20:06pm

Christian Graus

Comments

Nagy Vilmos 30-Jul-12 4:07am

I'll have to ding you there. toLocaleString() gives the date & time, toLocaleDateString() gives just the date, which I am more interested in and toLocaleTimeString() just the time part.
But the part I am flummoxed by is a similar thing for numbers.

jasmin_patel · Answer 2 · 2012-07-29T20:58:00

C#

DateTime date=DateTime.Now;
        //Sets the CurrentCulture property to U.S. English.
        System.Globalization.CultureInfo c2 = new System.Globalization.CultureInfo("en-US");
        Label1.Text = date.ToString("d",c2);

C#

// Creates a CultureInfo for German in Germany.
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("de-DE");
Label2.Text = date.ToString("d",ci);

set For
us = CultureInfo("en-US");
british = CultureInfo("en-GB");
danish = CultureInfo("da");

and for more CultureInfo http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo(v=vs.71).aspx[^]

enhzflep · Answer 3 · 2012-07-30T00:07:00

I'm not terribly confident that my answer wont be met with rolling eyes or hostility - it certainly is fairly sloppy - though it does appear to at least work.

I guess you could always (shudder) examine the returned string representation of the date as a means of guessing/determining the appropriate routine to use to convert the number.

When run, the output is

3,141,592.653589793
3141592,653589793

HTML

<!DOCTYPE html>
<html>
<head>
<script>
    function convNum()
    {
    	var inNum = 1000000 * 3.141592653589793;
    	document.getElementById('ukUs').innerHTML = toUkUs(inNum);
    	document.getElementById('hung').innerHTML = toHung(inNum);
    }
    
    function toHung(num)
    {
    	var str = String(num);
    	return str.replace('.', ',');
    }
    
    function toUkUs(num)
    {
    	var str = thousandSeparator(num,',');
    	var n=str.indexOf(".");
    	var preDec = str.substring(0,n);
    	var postDec ='';
    	
    	for (i=n; i<str.length; i++)
    	{
    		if (str.charAt(i) != ',')
    			postDec += str.charAt(i);
    	}
    	return preDec + postDec;
    }
    
    function thousandSeparator(n,sep) {
    	var sRegExp = new RegExp('(-?[0-9]+)([0-9]{3})'), sValue=n+'';
    	
    	if (sep === undefined) {sep=',';}
    	while(sRegExp.test(sValue)) {
    		sValue = sValue.replace(sRegExp, '$1'+sep+'$2');
    	}
    	return sValue;
    }
</script>
</head>
<body>
    <span>1000000 * &pi;</span><button onclick="convNum();">Get number</button><br>
    <div id="ukUs"></div>
    <div id="hung"></div>
</body>
</html>

Formatting Dates and Times

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0