How can I get Now() to use the client date/time - NOT SERVER? 1

DrmWvr · Apr 30, 2002

Hi Guys,
this web site, I'm working on, is posting messages from across Canada and various time zones. Is there any way to get the local time into the SQL query below? Right now it is using the time from the web server, which is located one time zone to the east. And is one hour ahead.

<CFQUERY NAME="Update" DATASOURCE="autonews">

INSERT INTO NewsMessages (title_e, title_f, itc_e, itc_f, message_e, message_f, <b>date_posted</b>, Expire)

VALUES ('#form.title_e#','#form.title_f#','#form.itc_e#','#form.itc_f#','#form.message_e#','#form.message_f#', <b>#CreateODBCDateTime(Now())#</b>,'#DateFormat(form.expire,"DD/MM/YYYY&quot

#')

</CFQUERY>

Thanks ahead of time.
I owe you one,
Marc
Québec, Canada

DrmWvr · Apr 30, 2002

Ok, I guess I have to use Javascript, because it processes on the client and not the server. However, Javascript doesn't seem to have comparable Dateformat, Timeformat and Now fuctions.

Any suggestions?

Marc

DrmWvr · Apr 30, 2002

That should read as Functions. Does this web site allow editing of threads?

tleish · Apr 30, 2002

Something like this could work:

<SCRIPT LANGUAGE="JavaScript">
[COLOR=666666]<!--[/color]
[COLOR=666666]/****************************** dateformat *********************************
*
* Object Extension for Date object
* description:
* -Stores day and month arrays in Date object
* -Provides a format function to 'pretty' print
* the date in custom formats
* parameters:
* format - accpets any variation of the following list
* yyyy is a 4-digit year - i.e., 2002
* yy is a 2-digit year - i.e., 02
* month is the full month - i.e., September
* mon is the first three letters of the month - i.e., Sep
* mmm is the number of the month - i.e., 9
* hh is hours - i.e., 3
* mm is minutes (always 2-digit) - i.e., 05
* ss is seconds (always 2-digit) - i.e., 08
* ddd is the first three letters of the day - i.e., Wed
* dd is the numerical day of the month - i.e, 25
* day is the full day of the week - i.e., Wednesday
* timezone is the the timezone in hours from GMT - i.e., GMT+5
* time24 is the time based on a 24 hour clock - i.e., 18:24
* time is the time based on am/pm - i.e., 6:24PM
* example:
* myDate = new Date()
* myDate.format("day, month dd, yyyy hh:mm:ss timezone&quot
* would return "Wednesday, September 25, 2002 12:14:11 GMT-5"
******************************************************************************/[/color]
[COLOR=666666]//Store the date info in the Date object[/color]
Date.prototype.Months =

Code:

"January", "February", "March",
"April", "May", "June", "July",
"August", "September", "October",
"November", "December"

Code:

;
Date.prototype.Days =

Code:

"Sunday", "Monday", "Tuesday",
"Wednesday", "Thursday",
"Friday", "Saturday"

Code:

;
Date.prototype.format = dateFormat;

function dateFormat(format) {
var dateString = format;

[COLOR=666666]//yyyy is a 4-digit year - i.e., 2002 [/color]
dateString = dateString.replace( new RegExp("yyyy", "gi"), this.getYear() );
[COLOR=666666]//yy is a 2-digit year - i.e., 02[/color]
dateString = dateString.replace( new RegExp("yy", "gi"), new String( this.getYear() ).substring(2,4) );
[COLOR=666666]//month is the full month - i.e., September[/color]
dateString = dateString.replace( new RegExp("month", "gi"), this.Months

Code:

this.getMonth()

Code:

);
[COLOR=666666]//mon is the first three letters of the month - i.e., Sep[/color]
dateString = dateString.replace( new RegExp("mon", "gi"), new String( this.Months

Code:

this.getMonth()

Code:

).substring(0,3) );
[COLOR=666666]//mmm is the number of the month - i.e., 9[/color]
dateString = dateString.replace( new RegExp("mmm", "gi"), (this.getMonth() + 1) );
[COLOR=666666]//hh is hours - i.e., 3[/color]
dateString = dateString.replace( new RegExp("hh", "gi"), this.getHours() );
[COLOR=666666]//mm is minutes (always 2-digit) - i.e., 05[/color]
var mm = new String( this.getMinutes() );
if (mm.length == 1) mm = "0" + mm; [COLOR=666666]//pad if single digit[/color]
dateString = dateString.replace( new RegExp("mm", "gi"), mm );
[COLOR=666666]//ss is seconds (always 2-digit) - i.e., 08[/color]
var ss = new String( this.getSeconds() );
if (ss.length == 1) ss = "0" + mm; [COLOR=666666]//pad if single digit[/color]
dateString = dateString.replace( new RegExp("ss", "gi"), ss );
[COLOR=666666]//ddd is the first three letters of the day - i.e., Wed[/color]
dateString = dateString.replace( new RegExp("ddd", "gi"), new String( this.Days

Code:

this.getDay()

Code:

).substring(0,3) );
[COLOR=666666]//dd is the numerical day of the month - i.e, 25[/color]
dateString = dateString.replace( new RegExp("dd", "gi"), this.getDate() );
[COLOR=666666]//day is the full day of the week - i.e., Wednesday[/color]
dateString = dateString.replace( new RegExp("day", "gi"), this.Days

Code:

this.getDay()

Code:

);

[COLOR=666666]//timezone is the the timezone in hours from GMT - i.e., GMT+5[/color]
tz = this.getTimezoneOffset();
timezone = "";
if (tz < 0)
timezone = "GMT-" + tz / 60;
else if (tz == 0)
timezone = "GMT";
else
timezone = "GMT+" + tz / 60;
dateString = dateString.replace( new RegExp("timezone", "gi"), timezone );

[COLOR=666666]//time24 is the time based on a 24 hour clock - i.e., 18:24 [/color]
var minutes = new String( this.getMinutes() );
if (minutes.length == 1) minutes = "0" + minutes; [COLOR=666666]//pad if single digit[/color]
var time24 = new String( this.getHours() + ":" + minutes );
dateString = dateString.replace( new RegExp("time24", "gi"), time24 );

[COLOR=666666]//time is the time based on am/pm - i.e., 6:24PM[/color]
var time;
var ampm;
var hour = this.getHours();
if ( hour < 12) {
if (hour == 0) hour = 12;
ampm = "AM"
} else {
if (hour !=12)
hour = hour - 12;
ampm = "PM";
}
time = new String(hour + ":" + minutes + ampm);
dateString = dateString.replace( new RegExp("time", "gi"), time );

return dateString;
}

[COLOR=666666]//-->[/color]
</SCRIPT>

<SCRIPT LANGUAGE="JavaScript">
[COLOR=666666][/color]
</SCRIPT> - tleish

DrmWvr · Apr 30, 2002

Thanks tleish,
it all works fine except for the year, which keeps showing 102 rather than 2002.

Marc

tleish · Apr 30, 2002

I hadn't checked on Netscape. To make JavaScript 1.2 ECMA-Script compliant, Netscape engineers changed the definition of getYear(). Now, getYear() will return the specified year minus 1900, as shown in Code Fragment #2.

So, I've replaced getYear() with getFullYear(). Here are the corrections:

<script language="JavaScript1.2">
[COLOR=666666]<!--[/color]
[COLOR=666666]/****************************** dateformat *********************************
*
* Object Extension for Date object
* description:
* -Stores day and month arrays in Date object
* -Provides a format function to 'pretty' print
* the date in custom formats
* parameters:
* format - accpets any variation of the following list
* yyyy is a 4-digit year - i.e., 2002
* yy is a 2-digit year - i.e., 02
* month is the full month - i.e., September
* mon is the first three letters of the month - i.e., Sep
* mmm is the number of the month - i.e., 9
* hh is hours - i.e., 3
* mm is minutes (always 2-digit) - i.e., 05
* ss is seconds (always 2-digit) - i.e., 08
* ddd is the first three letters of the day - i.e., Wed
* dd is the numerical day of the month - i.e, 25
* day is the full day of the week - i.e., Wednesday
* timezone is the the timezone in hours from GMT - i.e., GMT+5
* time24 is the time based on a 24 hour clock - i.e., 18:24
* time is the time based on am/pm - i.e., 6:24PM
* example:
* myDate = newDate()
* myDate.format("day, month dd, yyyy hh:mm:ss timezone&quot
* would return "Wednesday, September 25, 2002 12:14:11 GMT-5"
******************************************************************************/[/color]
[COLOR=666666]//Store the date info in the Date object[/color]
Date.prototype.Months =

Code:

"January", "February", "March",
"April", "May", "June", "July",
"August", "September", "October",
"November", "December"

Code:

;
Date.prototype.Days =

Code:

"Sunday", "Monday", "Tuesday",
"Wednesday", "Thursday",
"Friday", "Saturday"

Code:

;
Date.prototype.format = dateFormat;

function dateFormat(format) {
var dateString = format;

[COLOR=666666]//yyyy is a 4-digit year - i.e., 2002 [/color]
dateString = dateString.replace( new RegExp("yyyy", "gi"), this.getFullYear() );
[COLOR=666666]//yy is a 2-digit year - i.e., 02[/color]
dateString = dateString.replace( new RegExp("yy", "gi"), new String( this.getFullYear() ).substring(2,4) );
[COLOR=666666]//month is the full month - i.e., September[/color]
dateString = dateString.replace( new RegExp("month", "gi"), this.Months

Code:

this.getMonth()

Code:

);
[COLOR=666666]//mon is the first three letters of the month - i.e., Sep[/color]
dateString = dateString.replace( new RegExp("mon", "gi"), new String( this.Months

Code:

this.getMonth()

Code:

).substring(0,3) );
[COLOR=666666]//mmm is the number of the month - i.e., 9[/color]
dateString = dateString.replace( new RegExp("mmm", "gi"), (this.getMonth() + 1) );
[COLOR=666666]//hh is hours - i.e., 3[/color]
dateString = dateString.replace( new RegExp("hh", "gi"), this.getHours() );
[COLOR=666666]//mm is minutes (always 2-digit) - i.e., 05[/color]
var mm = new String( this.getMinutes() );
if (mm.length == 1) mm = "0" + mm; [COLOR=666666]//pad if single digit[/color]
dateString = dateString.replace( new RegExp("mm", "gi"), mm );
[COLOR=666666]//ss is seconds (always 2-digit) - i.e., 08[/color]
var ss = new String( this.getSeconds() );
if (ss.length == 1) ss = "0" + mm; [COLOR=666666]//pad if single digit[/color]
dateString = dateString.replace( new RegExp("ss", "gi"), ss );
[COLOR=666666]//ddd is the first three letters of the day - i.e., Wed[/color]
dateString = dateString.replace( new RegExp("ddd", "gi"), new String( this.Days

Code:

this.getDay()

Code:

).substring(0,3) );
[COLOR=666666]//dd is the numerical day of the month - i.e, 25[/color]
dateString = dateString.replace( new RegExp("dd", "gi"), this.getDate() );
[COLOR=666666]//day is the full day of the week - i.e., Wednesday[/color]
dateString = dateString.replace( new RegExp("day", "gi"), this.Days

Code:

this.getDay()

Code:

);

[COLOR=666666]//timezone is the the timezone in hours from GMT - i.e., GMT+5[/color]
tz = this.getTimezoneOffset();
timezone = "";
if (tz < 0)
timezone = "GMT-" + tz / 60;
else if (tz == 0)
timezone = "GMT";
else
timezone = "GMT+" + tz / 60;
dateString = dateString.replace( new RegExp("timezone", "gi"), timezone );

[COLOR=666666]//time24 is the time based on a 24 hour clock - i.e., 18:24 [/color]
var minutes = new String( this.getMinutes() );
if (minutes.length == 1) minutes = "0" + minutes; [COLOR=666666]//pad if single digit[/color]
var time24 = new String( this.getHours() + ":" + minutes );
dateString = dateString.replace( new RegExp("time24", "gi"), time24 );

[COLOR=666666]//time is the time based on am/pm - i.e., 6:24PM[/color]
var time;
var ampm;
var hour = this.getHours();
if ( hour < 12) {
if (hour == 0) hour = 12;
ampm = "AM"
} else {
if (hour !=12)
hour = hour - 12;
ampm = "PM";
}
time = new String(hour + ":" + minutes + ampm);
dateString = dateString.replace( new RegExp("time", "gi"), time );

return dateString;
}

[COLOR=666666]//-->[/color]
</script>

<script language="JavaScript">
[COLOR=666666][/color]
</script> - tleish

DrmWvr · Apr 30, 2002

Ok, thanks again tleish!
Marc

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How can I get Now() to use the client date/time - NOT SERVER? 1

DrmWvr

Programmer

DrmWvr

Programmer

DrmWvr

Programmer

tleish

Programmer

DrmWvr

Programmer

tleish

Programmer

DrmWvr

Programmer

Similar threads

Part and Inventory Search

Sponsor