> also because in some cases there are version differences.
Right, and my DB2 isn't v8. It's a pain in the tuckus to deal with
too... I'd love to be on something a bit more modern.
Chris
David L. Penton wrote:
Almost... ;-)
For you, using DB2 timestamp is much different than on SQL Server.
From the DB2 UDB v8 docs:
<db2_timestamp>
The internal representation of a timestamp is a string of 10 bytes.
Each byte consists of 2 packed decimal digits. The first 4 bytes
represent the date, the next 3 bytes the time, and the last 3 bytes
the microseconds.
</db2_timestamp>
Even more confusion!
Moral of the story: whatever database you are using, learn (maybe
even memorize) the datatypes and relative limits. I still have to
revert back to the manuals for this stuff - also because in some cases
there are version differences.
- dave
Christopher Jordan wrote:
Ah! see? there is a difference between DateTime and Timestamp. I'm
using DB2 on a very old AS400, and I'm not sure there's a
distinction. My only options when creating a table are "Date",
"Time", and "TimeStamp". Thanks Dave! :)
Chris
David L. Penton wrote:
If I was/am doing date-only things, I use datetime
If I know what the actual range of dates are and know they would
never move out of the smalldatetime realm, I'd use smalldatetime
(fyi...I try to never use smalldatetime)
If I was looking to do concurrency checking with a database, I use
timestamp. Note a timestamp is binary(8). Even though the name
suggests it, this datatype has nothing to do with dates in the
conventional sense.
Use datetime, if you continue to use raw sql use cfqueryparams, if
not I'd suggest using a stored procedure instead. Then you are
using tags only with no raw text (except the procedure name) and you
have more control over the query execution.
...and I hope I didn't confuse matters more on this by interjecting
my $0.02 opinion. Date/Time can be a complicated subject.
- dave
Mark Armstrong wrote:
should I be using datetime? I only need the date, so not sure,
looks like there is datetime, timestamp, smalldatetime...
too confusing.
Mark
On Jun 6, 2006, at 2:01 PM, Christopher Jordan wrote:
Also, using the proper Date/Timestamp/etc. data type eliminates
problems with consistency across tables. One table might hold a
date as MM/DD/YY while another as MM/DD/YYYY and another as
YYYY/MM/DD or YY-MM-DD or MM-DD-YYYY or... etc... you get the
idea. :)
Chris
Christopher Jordan wrote:
Mark,
As a general rule, I always store dates as date types (or
timestamps) rather than as string representations of dates
(YYYY-MM-DD) or even as numeric representations of dates
(YYYYMMDD)... it's helpful when you want to do date comparisons
and such that your dates will already be formatted correctly, and
ColdFusion will already be able to understand them properly.
That is, of course, just my opinion. :)
Chris
Dave Shuck wrote:
Mark, have you tried:
WHERE .... duedate=#CreateODBCDate(duedate)#
or even better...
WHERE .... duedate = <cfqueryparam type="cf_sql_date"
value=#CreateODBCDate(duedate)# />
~d
On 6/6/06, Mark Armstrong <[EMAIL PROTECTED]> wrote: Sorry, MSSQL
7. table, meaning the "tasks" table that I am storing
the data.
On Jun 6, 2006, at 1:27 PM, Matt Woodward wrote:
> When you say "in the table" what specifically do you mean? What
> database are you using?
>
> On 6/6/06, Mark Armstrong <[EMAIL PROTECTED]> wrote:
>> OK,
>>
>> I give up!!! I cannot seem to get the date to work correctly.
(to
>> insert, modify or output the data in the table).
>>
>> I am CF formatting the date, properly, but its not showing up
in the
>> table anything other than 01/01/01.
>>
>> When I modify the form to insert the new values, its still the
>> same... what can I be doing wrong?
>>
>> The output page is this: #DateFormat(duedate,"MM-DD-YY")#
>>
>> the modify page looks like this:
>>
>> <cfset duedate1 = DateFormat(#duedate#, "mm/dd/yy")>
>>
>> <input name="duedate" type="text" value="#duedate1#"
>> cfsqltype="CF_SQL_DATE" />
>>
>> and the modify page posts to the update processing page:
>>
>> UPDATE tasks
>> SET taskname = '#taskname#', taskdescription =
'#taskdescription#',
>> first_name='#first_name#', weburl='#weburl#', test='#test#',
>> visual='#visual#', comments='#comments#', duedate=#duedate#
>> WHERE taskID = #form.taskID#
>>
>> Any help is appreciated!
>>
>> Mark
_______________________________________________
Reply to DFWCFUG: [email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
