Military Time Problem

Scott · Jan 25, 2006

If I have a datetime sql field with afternoon datetime values like below in
DATETIME VALUE, how can I display the time part in ASP as 1:00 PM, instead
of 13:00 PM as seen in CURRENT RESULTS below?

Currently, I'm getting my CURRENT RESULTS by using the HOUR() function. Is
there a way to display just the time part in "non-Military" time format?

DATETIME VALUE:
2006-01-24 13:30:00.000

CURRENT RESULTS::
13:30 PM

DESIRED RESULTS:
1:30 PM

dNagel · Jan 25, 2006

I've worked up an example that procduced the desired result .. it is
_slightly tested_ ...

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1250">
<meta name="generator" content="PSPad editor, www.pspad.com">
<title></title>
</head>
<body>
<pre>
You are going to experience problems with this method unless you format your
Date from SQL in an acceptable format ( as presented below ) before it hits
your JS code.

01-24-2006 13:30:00
</pre>

<script>
// this is where you format your date with server side code
// I'm using your hard coded value for now

var someDate= new Date('01-24-2006 13:30:00');

document.write ( '<pre>' + someDate.toString() + '<br />')

with (someDate)
{
document.write ( getHours() % 12 + ':' + getMinutes() +
( parseInt(getHours()) > 12 ? ' PM' : ' AM') + '</pre>')
}

</script>
</body>
</html>

hth,

D.

dNagel · Jan 25, 2006

If you do this a lot you might want to consider adding a new prototype to
the Date object...

<script>

Date.prototype.humanTime = function () {
var sDate = new String();
sDate = ( this.getHours() % 12 + ':' + this.getMinutes() + ( parseInt(this.getHours()) > 12 ? ' PM' : ' AM') )
return (sDate.toString())
}
var someDate= new Date('01-24-2006 13:30:00');
document.write ( '<pre>' + someDate.toString() + '<br />')
document.write ( someDate.humanTime() + '<br />')

var sNow = new Date()
document.write ( 'The time is now : ' + sNow.humanTime() )

document.write ( '</pre>' )

</script>

hth,

D.

dNagel · Jan 25, 2006

ok, too much beer tonight...

I blew it on 12am , and 12pm...

replace the prototype with this ...

Date.prototype.humanTime = function () {
var sDate = new String(), sHour = new String(), sAMPM = new String();
sHour = this.getHours() % 12 ;
sAMPM = parseInt(this.getHours()) > 11 ? ' PM' : ' AM';
if (sHour == 0) sHour = 12;
sDate = sHour + ':' + this.getMinutes() + sAMPM;
return (sDate.toString());
}

D.

Scott · Jan 27, 2006

thanks guys.

dNagel said:
ok, too much beer tonight...

I blew it on 12am , and 12pm...

replace the prototype with this ...

Date.prototype.humanTime = function () {
var sDate = new String(), sHour = new String(), sAMPM = new String();
sHour = this.getHours() % 12 ;
sAMPM = parseInt(this.getHours()) > 11 ? ' PM' : ' AM';
if (sHour == 0) sHour = 12;
sDate = sHour + ':' + this.getMinutes() + sAMPM;
return (sDate.toString());
}

D.

C# How to convert date into en-US when thread culture is ar-SA	1	Feb 18, 2021
Help with code	0	Jun 12, 2022
Pick time out of datetime	1	Aug 17, 2009
New to coding - image to the time of day based on time	2	May 14, 2022
Help with my responsive home page	2	Dec 14, 2022
Trying to build a SARIMAX model to forecast the S&P500 trend	0	Nov 5, 2023
Help figuring out a directory permission change problem	1	May 12, 2023
Hrs worked between two dates crossing over midnight	3	Feb 10, 2023

Military Time Problem

Scott

dNagel

dNagel

dNagel

Scott

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads