It's been one of those days already - can anyone tell me why the time gets
stripped out? I'm aware that I'm using 'date' as an argument type, but
datetime throws an error and there's nothing in CF8 docs on it... How do I
preserve the time data?
cffunction name=dateFormatter2
a Date Time Value to a function
It's been one of those days already - can anyone tell me why the time gets
stripped out? I'm aware that I'm using 'date' as an argument type, but
datetime throws an error and there's nothing in CF8 docs on it... How do I
preserve the time data?
cffunction name
From: Tom King mailingli...@oxalto.co.uk
Sent: Wednesday, August 18, 2010 8:26 AM
To: cf-talk cf-talk@houseoffusion.com
Subject: Passing a Date Time Value to a function
It's been one of those days already - can anyone tell me why the time gets
stripped out? I'm aware that I'm using 'date
Hi
I am trying to insert the current date and time into an Oracle db using
the following
cfqueryparam cfsqltype=cf_sql_varchar value=#LSDateFormat(Now(),
dd-mmm-)# #LSTimeFormat(Now())#
But I am getting the following coldfusion error from the database?
Error Executing Database Query.
Is the column a date or a varchar - because you're using a varchar cfsqltype.
I usually use the Oracle to_date() function to insert a date/time.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/8/18 Ian Vaughan i.vaug...@neath-porttalbot.gov.uk:
Hi
I am
Is the column a date or a varchar - because you're using a varchar cfsqltype.
I usually use the Oracle to_date() function to insert a date/time.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
I use MS SQL Server, but I think you could use something like
:
Is the column a date or a varchar - because you're using a varchar cfsqltype.
I usually use the Oracle to_date() function to insert a date/time.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
I use MS SQL Server, but I think you could use something like
On Tue, Aug 18, 2009 at 11:42 AM, Stephen Weyricksweyr...@gmail.com wrote:
If this doesn't work, try this...
cfqueryparam value=#CreateODBCTime(now())# CFSQLType=cf_sql_timestamp /
I'm pretty sure the createODBCDate() function (and like functions) are
only necessary when you're NOT using
I am having a problem with erroneous MINUTES in my DateTime
creation/formatting.
The rest of the DateTime comes out correctly.LINK
OUTPUT ...
Date Formatting tests
vStartDate = 01/01/2000 vEndDate = 14/4/2009
CreateDateTime (vStartDate) = {ts
You can't output a time with dateformat() - you need to use
timeformat() for that bit.
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
2009/4/15 BobSharp bobsh...@ntlworld.com:
I am having a problem with erroneous MINUTES in my DateTime
creation/formatting.
-
From: James Holmes james.hol...@gmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Wednesday, April 15, 2009 2:22 PM
Subject: Re: Newbie ... Date / Time formatting
You can't output a time with dateformat() - you need to use
timeformat() for that bit.
mxAjax / CFAjax docs and other useful
Automatically Adjust for
Daylight Savings Time option and manually reset the system date/time to the
correct time. Apparently Windows adjusted only the clock display and not the
system date/time.
Everyone running Windows systems may want to check this if they are using CF
date/time functions. I'm sure
was showing the correct time, but my CF generated dates and
times were an hour off (behind an hour). This was affecting data base
postings, timestamps, etc.
To correct this I had to turn off the systems Automatically Adjust for
Daylight Savings Time option and manually reset the system date/time
Is your version of Java patched for the latest daylight savings dates?
mxAjax / CFAjax docs and other useful articles:
http://www.bifrost.com.au/blog/
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
, 2009 1:22 PM
To: cf-talk
Subject: (sot) CF and Section 508 compliance a 508 compliant date/time
picker
We just picked up a site that needs to be 508 compliant. I am getting a
crash course right now. I (or any of us really) never made a site/app that
needed to be 508 compliant.
My only
[mailto:ju...@wiredotter.com]
Sent: Friday, February 20, 2009 11:31 PM
To: cf-talk
Subject: Re: (sot) CF and Section 508 compliance a 508 compliant date/time
picker
I'd also recommend looking at the ARIA (accessible rich internet
applications) initiative through the W3C:
http://www.w3.org/WAI/PF/aria
that there
are plans to do so in a future release.
-Original Message-
From: Judah McAuley [mailto:ju...@wiredotter.com]
Sent: Friday, February 20, 2009 11:31 PM
To: cf-talk
Subject: Re: (sot) CF and Section 508 compliance a 508 compliant date/time
picker
I'd also recommend looking
server side validation as well?
Also.. Does anyone know of any 508 compliant date/time pickers? Those are
going to be the only JS widgets that may be an issue.
And lastly, anyone care to pass on any general advice or gotchas and/or
advice on that to be aware of and/or be careful of etc.
As always
Gerald Guido wrote:
using CFForm will be an issue. Yes I know... we shouldn't use CFForm etc..
but it is uber-crunch time and that is what our code generator spits out.
I'm curious, what are the current torch and pitchfork arguments against
using CFFORM? In the past it was terrible and I
Also.. Does anyone know of any 508 compliant date/time pickers? Those
are going to be the only JS widgets that may be an issue.
Any date-picker should be fine, provided that the widget is used to
populate a text field that can also be manually entered. I integrated
the Dynarch widget
AM
To: cf-talk
Subject: (sot) CF and Section 508 compliance a 508 compliant date/time
picker
We just picked up a site that needs to be 508 compliant. I am getting a
crash course right now. I (or any of us really) never made a site/app that
needed to be 508 compliant.
My only concern is the use
Any date-picker should be fine, provided that the widget is used to
populate a text field that can also be manually entered.
Thanx Ike,
So if I understand correctly, if I have a date/time widgets that can can be
used as (or considered to be) a convenience or an adjunct, but not the
primary
Any date-picker should be fine, provided that the widget is used to
populate a text field that can also be manually entered.
Thanx Ike,
So if I understand correctly, if I have a date/time widgets that can can be
used as (or considered to be) a convenience or an adjunct
I'm curious, what are the current torch and pitchfork arguments against
using CFFORM?
No reason for me to bring it up other than to avoid having the post
derailed. I have seen it brought up a few times tends though not as bad as
evaluate(). I have been using CF form for years with out a problem
If we have time we will roll our own, prolly using spry as long as it
doesn't conflict with the Dynarch widget like said it could/would.
You can work around that by disabling Spry's date hints for
date-validated text fields.
--
s. isaac dealey ^ new epoch
isn't it time for a change?
Subject: (sot) CF and Section 508 compliance a 508 compliant date/time
picker
We just picked up a site that needs to be 508 compliant. I am getting a
crash course right now. I (or any of us really) never made a site/app that
needed to be 508 compliant.
My only concern is the use of JS
date/time
picker
We just picked up a site that needs to be 508 compliant. I am getting a
crash course right now. I (or any of us really) never made a site/app that
needed to be 508 compliant.
My only concern is the use of JS. It is basically a data entry and reporting
app and there is going
On 5/21/07, Mike Chabot [EMAIL PROTECTED] wrote:
Perhaps CreateOdbcDate() is what you are after.
I don't agree with this. CreateODBCDate() is only necessary if you're
not using cfqueryparam
The correct, safe and secure solution is to use
cfqueryparam cfsqltype=cf_sql_date value=05/22/2007
or
I'm converting a CF application from Oracle to MS SQL 2005 and found out
that when you insert a date in to a datetime field in SQL, it creates a
time (00:00:00) that includes either AM or PM according to when the
record was inserted. What would be the best way to create a safe date
to insert that
://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:51779
~Brad
-Original Message-
From: Rebecca Wells [mailto:[EMAIL PROTECTED]
Sent: Monday, May 21, 2007 7:06 PM
To: CF-Talk
Subject: T-SQL Date/Time
PLEASE REPLY TO ME OFF LIST AT [EMAIL PROTECTED] AS I AM ON DIGEST
AND DON'T HAVE TIME TO WADE
Perhaps CreateOdbcDate() is what you are after.
-Mike Chabot
On 5/21/07, Rebecca Wells [EMAIL PROTECTED] wrote:
I'm converting a CF application from Oracle to MS SQL 2005 and found out
that when you insert a date in to a datetime field in SQL, it creates a
time (00:00:00) that includes either
: java.lang.NumberFormatException: Invalid date/time
This happens anytime there is a Date/Time in the XML returned.
Has anyone seen this before? Is there some way to pass through an XSLT to
transform the return so Coldfusion can understand these variables?
Below I've attached the XML that is returned.. I believe
I want to compare dates in my Access database. It is setup as a date/time field
in Access as expiration.
I want to check whether the expiration date matches a cfset date. I tried every
combination with or without quotes, single quotes, the = sign or EQ, but since
I don't always do CF
PROTECTED]
Sent: Wednesday, March 07, 2007 10:13 AM
To: CF-Talk
Subject: querying a date/time field
I want to compare dates in my Access database. It is setup as a
date/time field in Access as expiration.
I want to check whether the expiration date matches a cfset date. I
tried every combination
ew access...
try
where expiration = cfqueryparam cfsqltype=cf_sql_date value=#fooDate# /
On 3/7/07, Orlini, Robert [EMAIL PROTECTED] wrote:
I want to compare dates in my Access database. It is setup as a date/time
field in Access as expiration.
I want to check whether the expiration
ew access...
This has nothing to do with Access.
The problem is that formated dates should not be used in SQL, only CF
date values (which are automatically converted t ODBCdates by default),
or better use ODCDates.
Secondly, quotes should nor be used with dates in SQL
This should work:
it might not have anything to do with Access but doesn't mean I have
to like Access..
On 3/7/07, Claude_Schnéegans [EMAIL PROTECTED] wrote:
ew access...
This has nothing to do with Access.
The problem is that formated dates should not be used in SQL, only CF
date values (which are
On 3/7/07, Claude_Schnéegans [EMAIL PROTECTED] wrote:
CFSET thirdletterdate = DateAdd(d, -7, get.expiration)
cfquery name=Getnow datasource=trials
Select * from trials_info
where expiration eq #CreateODBCDate(thirdletterdate)#
order by expiration desc
/cfquery
This should work, provided
I have been doing this wrong for years and getting by with it. What is the
correct way?
I have a field in my SQL Server 2005 PageHits table for the current date and
time. What data format should the field be? What value do I pass from CF?
CreateODBCDateTime(Now)) I get an error when I try
CreateODBCDateTime(Now))
Does CreateODBCDataTime(Now()) work better? I use this all the time.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-
| 1 | |
- Binary Soduko
| | |
-
C code. C code run. Run code run. Please!
-
://www.reedexpo.com
-Original Message-
From: Tim Claremont
To: CF-Talk
Sent: Thu Jan 25 16:33:15 2007
Subject: Insert Current Date/Time into SQL DB (CF101)
I have been doing this wrong for years and getting by with it. What is the
correct way?
I have a field in my SQL Server 2005 PageHits
On 1/25/07, Tim Claremont [EMAIL PROTECTED] wrote:
I have been doing this wrong for years and getting by with it. What is the
correct way?
I have a field in my SQL Server 2005 PageHits table for the current date and
time. What data format should the field be? What value do I pass from CF?
Nope.
My field's datatype is currently set to timestamp. I have a variable named
HitTime set as follows:
CFSET HitTime = #CreateODBCDateTime(Now())#
Upon insert I get an Incorrect Syntax error on my page.
~|
Upgrade to Adobe
CFSET HitTime = #CreateODBCDateTime(Now())#
The Now() function returns an ODBC timestamp value, so there's no need to
use CreateODBCDateTime with it.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our
I have been doing this wrong for years and getting by with
it. What is the correct way?
I have a field in my SQL Server 2005 PageHits table for the
current date and time. What data format should the field be?
What value do I pass from CF? CreateODBCDateTime(Now)) I
get an error
-Original Message-
From: Charlie Griefer
To: CF-Talk
Sent: Thu Jan 25 17:50:02 2007
Subject: Re: Insert Current Date/Time into SQL DB (CF101)
On 1/25/07, Tim Claremont [EMAIL PROTECTED] wrote:
I have been doing this wrong for years and getting by with it. What is the
correct way?
I have
to do the insertion.
-Original Message-
From: Charlie Griefer
To: CF-Talk
Sent: Thu Jan 25 17:50:02 2007
Subject: Re: Insert Current Date/Time into SQL DB (CF101)
On 1/25/07, Tim Claremont [EMAIL PROTECTED] wrote:
I have been doing this wrong for years and getting by with it. What
I assume the SQL-Server datatype is datefime? Could you give an example
of using getDate() in a sql update statement, please?
Rick Colman
why pass anything from CF? why not just make the default value of the
field in the database getDate()?
if you're updating...just pass
In my opinion, in most situations, the best way is not to do it from CF at
all. Simply define the default value within the database column. That way,
if you write future applications in other environments that use the same
database, they'll function identically.
Got it, Dave. Part of my problem
UPDATE
myTable
SET
updatedTime = getDate()
WHERE
recordID = cfqueryparam name=#rID# cfsqltype=cf_sql_integer /
On 1/25/07, Richard Colman [EMAIL PROTECTED] wrote:
I assume the SQL-Server datatype is datefime? Could you give an example
of using getDate() in a sql update statement,
Charlie Griefer wrote:
I've not done much with i18n, so I'm not really familiar with the
pros/cons of using getUTCDate() vs getDate(). Could you throw out a
few bullet points?
using UTC datetimes isn't really i18n. it's used if you need UTC timezone (tz)
data (like maybe you live in
On 1/25/07, Paul Hastings [EMAIL PROTECTED] wrote:
Charlie Griefer wrote:
I've not done much with i18n, so I'm not really familiar with the
pros/cons of using getUTCDate() vs getDate(). Could you throw out a
few bullet points?
using UTC datetimes isn't really i18n. it's used if you need
out if #thisfield# is a SQL date/time object so
I can output it as mm/dd/ instead of
2006-02-11 00:00:00.0
For some reason some of my users get this and excel interprets the date
field as 00:00:00.0 instead of the date, unless you go in and manually
change the format.
Any ideas
cfif IsDate(thisfield)
#DateFormat(blahblah)#
cfelse
whatever
/cfif
Would that work?
Will
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers,
Or maybe you'd needta extract that date out first with a ListFirst()?
cfset dateOnly = ListFirst(thisfield, )
cfif isValid(dateOnly)
Show this
cfelse
show that
/cfif
??
Will
~|
Introducing the Fusion Authority Quarterly
I just slapped myself on my forehead, thank you.
This worked fine:
cfoutput query=rsList
cfloop index=thisfield list=#fieldlist#
cfif IsDate(evaluate(#thisfield#))
#lsdateformat(evaluate(#thisfield#), mm/dd/)#
cfelse
#evaluate(#thisfield#)#
/cfif,
/cfloop#CHR(13)#
/cfoutput
On
Will,
It looks like isDate() will do what you need - to see if the string
can be converted to a date
You might want to look at parseDateTime() which will create a date
object from the date string.. may or may not be of any use
cfset test = 2006-02-11 00:00:00.0
cfoutput#parseDateTime(test)# |
Hi,
I have a question on i18n date and time display for local time zones.
Currently I have had all date and time stored and presented in the
server/local time zone, but I am interested in moving to storing all
that in UTC format, and displaying it in local time for what the
client/user prefers.
:callto:fraxxinus
-
| -Original Message-
| From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]
| Sent: Friday, July 07, 2006 09:52
| To: CF-Talk
| Subject: i18n date/time
|
| Hi,
|
| I have a question on i18n date
Hugo Ahlenius wrote:
Now I saw Paul H's post on his blog, so it seems like there is no easy
way to do this...
well actually there is. set you server tz to UTC bob's your uncle. if nopt
the
only other way to avoid the DST boundary issue is to use java epoch offsets.
| well actually there is. set you server tz to UTC bob's your uncle.
| if nopt the only other way to avoid the DST boundary issue is to use
| java epoch offsets.
Sorry Paul - but how does that help? You mean by just adding and
subtracting for the timezone manually? And why does the server tz
Hugo Ahlenius wrote:
Sorry Paul - but how does that help? You mean by just adding and
subtracting for the timezone manually? And why does the server tz need
you're missing the real issue.
to be UTC -- wouldn't it be enough to just handle all time in UTC in the
backend? So I am not sure if
I fired up Ben's tag last week from his recent blog entry on it. Very
slick, although NIST servers report GMT. You'll need DateAdd() for
your timezone calc. If you are on a shared server that function is
the way to go. If you are on a dedicated box I would use the free
NIST exe and schedule it
Maybe this will help too. It just came in this morning.
getNISTTime
Created by: Ben Forta ([EMAIL PROTECTED])
CF Version: ColdFusion MX
Obtains current time data from NIST Internet Time Service servers.
http://www.cflib.org/udf.cfm?id=1377
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
I have the same problem (hosting in the US) and I use Paul Hastings'
-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]
Sent: Sunday, 11 December 2005 4:16 p.m.
To: CF-Talk
Subject: local date time minus 17 hours
How do I get my local date and time when my ISP's local
(),
application.environment.timeZone)
-Original Message-
From: Matthew Walker
Sent: Monday, 12 December 2005 12:01 p.m.
To: 'cf-talk@houseoffusion.com'
Subject: RE: local date time minus 17 hours
I have the same problem (hosting in the US) and I use Paul Hastings'
-Original Message-
From
Thanks Matthew. I didnt know about that CFC. It does the same job I do,
changing for daylight savings etc, only it does it automatically, and i
think it's quite a bit more elegant than my way of doing it.
I'm going to change over to using this cfc as I work on my sites.
Cheers
Mike Kear
How do I get my local date and time when my ISP's local time is
17 hours behind me.
Many thanks
Seamus
Seamus Campbell Boldacious WebDesign
http://www.boldacious.com [EMAIL PROTECTED]
ph 02 6297 4883 mob 0410 609 267
How do I get my local date and time when my ISP's local time is
17 hours behind me.
DateAdd(h, 17, Now())
Paul
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
Get an ISP closer to you ;-)
dateadd(h, 17, now())
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Seamus Campbell [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 10, 2005 10:01 PM
To: CF-Talk
Subject: local date time minus 17 hours
Quotes around h... sorry
dateadd('h', 17, now())
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Bobby Hartsfield [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 10, 2005 10:37 PM
To: CF-Talk
Subject: RE: local date time minus 17
Seamus I have this issue too, hosting some of my sites in teh Midwest of the
USA, when I'm in Australia. So i have an application variable called
application.austime which I set in the Application.cfc file on all my
sites. Depending on where they are located in the world,
application.austime
Thanks Mike
I've tried that but I get a number ( eg 38698.3354861)
I'm using CFMX 7
Do you know why I'm getting this?
Exact code I'm using:
cfset application.austime= #now()# + #createTimeSpan(0,17,0,0)#
cfoutput#application.austime#/cfoutput
Ta
Seamus
You wrote
Mike Kear wrote:
And Yes, I know I could use Locale, but I developed this method of handling
locale has nothing to do w/timezone (tz) or DST.
it before I learned about locale. Anyway, Australian daylight savings
change dates differ from year to year as the politicians get it into their
]
Sent: Saturday, December 10, 2005 11:05 PM
To: CF-Talk
Subject: [Reply To] Re: FW: local date time minus 17 hours
Thanks Mike
I've tried that but I get a number ( eg 38698.3354861)
I'm using CFMX 7
Do you know why I'm getting this?
Exact code I'm using:
cfset application.austime= #now
To: CF-Talk
Subject: [Reply To] Re: FW: local date time minus 17 hours
Thanks Mike
I've tried that but I get a number ( eg 38698.3354861)
I'm using CFMX 7
Do you know why I'm getting this?
Exact code I'm using:
cfset application.austime= #now()# + #createTimeSpan(0,17,0,0)#
cfoutput
I am implementing a multi-lingual application. Admin users will have the
possibility to switch between languages and formats instantly. These are
my issues:
1. finding a javascript (pop up calendar to select date to insert into
field) that allows both formats mm/dd/ and dd.mm.. My current
3. How to process insert and update statements considering that the
display will be in different formats while SQL 2000 requests mm/dd/
I have no answer for the othe points, but for this one, the answer is that you
should convert the date to ODBCFormat.
See CF_convertDate here:
Michael Kettenring Personal wrote:
1. finding a javascript (pop up calendar to select date to insert into
http://www.dynarch.com/projects/calendar/
2. same for timeformats. any ideas?
??
3. How to process insert and update statements considering that the
display will be in different
I thought I posted this question yesterday but it doesn't seem that it ever was
posted.
The question is how to convert this date/time field that I receive in a
webservice to a standard date/time.
The value I pull is in this format: 2005-04-07T13:29:00.000-04:00
You cannot use
Jim Rathmann wrote:
I thought I posted this question yesterday but it doesn't seem that it ever
was posted.
The question is how to convert this date/time field that I receive in a
webservice to a standard date/time.
The value I pull is in this format: 2005-04-07T13:29:00.000-04:00
JR The value I pull is in this format:
JR 2005-04-07T13:29:00.000-04:00
Truncate the string to a dot(.) and replace T to a space
2005-04-07 13:29:00 is a correct date format for most SQL servers.
JR I need to be
JR able to store it to SQL server but when I try it as is I get an
JR error
Did you try any of the Parse Date/Time functions?
If that doesn't work, you can always build a function to parse the
date/time for you. This format looks like it should be consistent for
all dates/times.
M!ke
-Original Message-
From: Jim Rathmann [mailto:[EMAIL PROTECTED]
Sent
I have a question that I am not sure if ColdFusion can calculate. Is there any
way to convert a Date/Time field that is in Milliseconds to a readable
Date/Time using ColdFusion? You can do it using the following JavaScript:
var theDateObj = new Date(parseFloat(110838972));
var d
Jim...milliseconds are not a date...just a measure of time.
Now if you have a start date and are adding milliseconds to that date...then
you're making sense ;-)
Let us know what the situation is
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group
] wrote:
I have a question that I am not sure if ColdFusion can calculate. Is there
any way to convert a Date/Time field that is in Milliseconds to a readable
Date/Time using ColdFusion? You can do it using the following JavaScript:
var theDateObj = new Date(parseFloat(110838972));
var d
Prolly epoch time, seconds since jan 1 1970?
and sure, you can do that.
cfset myNewDate = dateAdd('s',millisecondsValueHere,'01/01/1970 00:00:00.000')
tw
On 4/27/05, Bryan Stevenson [EMAIL PROTECTED] wrote:
Jim...milliseconds are not a date...just a measure of time.
Now if you have a
.
M!ke
-Original Message-
From: Jim Rathmann [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 12:22 PM
To: CF-Talk
Subject: Convert Milliseconds to Date/Time
I have a question that I am not sure if ColdFusion can calculate. Is
there any way to convert a Date/Time field
Jim...milliseconds are not a date...just a measure of time.
Actually, it's common to use a number as a date, based on some starting
time. For example, Unix date values use the number of seconds since 1
January 1970.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software
nada barney
Could not convert the value 1.10838972E12 to an integer because it
cannot fit inside an integer.
On 4/27/05, Barney Boisvert [EMAIL PROTECTED] wrote:
If you're on CF7, give this a whirl:
#createObject(java, java.util.Date).init(javaCast(long, 110838972))#
On CF6.1 it
if you use Tony's make sure you multiply your milliseconds by 1000 to
get to seconds.
On 4/27/05, Tony Weeg [EMAIL PROTECTED] wrote:
Prolly epoch time, seconds since jan 1 1970?
and sure, you can do that.
cfset myNewDate = dateAdd('s',millisecondsValueHere,'01/01/1970
00:00:00.000')
Thanks for the help everyone it does seem as though it is epoch time. I have
never heard of that, but it does start on Jan 1, 1970 0:00:00.
Thanks again,
jim
~|
Find out how CFTicket can increase your company's customer support
Greg Morphis wrote:
if you use Tony's make sure you multiply your milliseconds by 1000 to
get to seconds.
I would love to have you as a customer and bill you using that
math, but my customers only accept it when I devide by 1000.
Jochem
What is the easiest way to convert the following string into a valid date/time
object? So as not to get the following error.
2005-01-31T06:00:00-08:00 is an invalid date format.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
C code. C code run. Run
Turn the T into a space.
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Monday, January 31, 2005 5:42 PM
To: CF-Talk
Subject: Easiest way to convert a string to a date/time object?
What is the easiest way to convert the following string into a valid
date
]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Monday, January 31, 2005 2:41 PM
Subject: Easiest way to convert a string to a date/time object?
What is the easiest way to convert the following string into a valid
date/time object? So as not to get the following error.
2005-01-31T06:00:00-08:00
Ian Skinner wrote:
What is the easiest way to convert the following string into a valid
date/time object? So as not to get the following error.
2005-01-31T06:00:00-08:00 is an invalid date format.
The easiest way is http://www.macromedia.com/go/wish/ and mention
that you want to vote
. Please!
- Cynthia Dunning
...-Original Message-
...From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
...Sent: Monday, January 31, 2005 3:04 PM
...To: CF-Talk
...Subject: Re: Easiest way to convert a string to a date/time object?
...
...Ian Skinner wrote:
... What is the easiest way
Ian Skinner wrote:
Where do you all find these issues and/or whishes enumerated on the
Macromedia site?
Nowhere. The only numbers I know are the ones I submitted myself
and have received feedback on (which isn't always).
Jochem
I have a form that if the date field is blank SQL automatically inserts the
date of 1/1/1900 and then this displays.
How can I have it leave this field blank? The column is set as datetime in
design view.
Thx.
Robert O.
~|
1 - 100 of 350 matches
Mail list logo