Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
fhilliard #1
Ordering Timestamp field in SQL
I've got a timestamp field that I want to order by date. In other words, all
the entries on a particular day should be grouped under that day, and so with
each preceeding day. Unfortunately, if I group by the timestamp field, nothing
is ordered because each timestamp is different (to the second). How do I do
this?
fhilliard Guest
-
Grouping and ordering
The manual says "MySQL extends the use of GROUP BY so that you can use non-aggregated columns or calculations in the SELECT list that do not appear... -
int4 -> unix timestamp -> sql timestamp; abstime?
Hello, what is the opposite of cast(extract('epoch' from now()) as int)? The only thing I found that works is cast(cast(... as abstime) as... -
Ordering by date ???
I have created a DB in Access 2000. The Date Field (clientdate) is currently a MEMO field. The date is being entered as: 10 June 2004 21... -
Ordering of recordsets
Create some links (or a drop-down <select> list) that the user can click on to select the way they want the collection ordered. Dynamically build... -
[PHP] File ordering
> I am doing a 'readdir' on a subdirectory. I did my file naming counting on Just sort the $imgFiles array. -- Lowell Allen -
PaulH #2 Re: Ordering Timestamp field in SQL
if you're talking about a timestamp in sql server, it's not really a "datetime"
data type. it's a "special" datatype, a "rowversion" to be specific. you might
try doing a CAST or CONVERT to a datetime though i'm not sure if this can be
done.
PaulH Guest
-
fhilliard #3 Re: Ordering Timestamp field in SQL
It's a date/time field in MS Access and I can use all the normal CF Time functions with it. What I'd really like to do is to do the SQL ORDER by dateformat(EnteredWhen) but this is illegal.
fhilliard Guest
-
fhilliard #4 Re: Ordering Timestamp field in SQL
I found the solution from frank at loofahcom.com. The secret is to enter both
an ODBC datetime and an ODBC date programatically in two separate fields. MS
Access adds a bunch of zeros, but you can group by the date field. Thank you
Frank!
fhilliard Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
