Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
gary@4reach.com #1
DatePart, 24-hour clock
Does anyone know how to display a DatePart hour in 24-hour clock
format?
I have extracted the hour from an form field (ODBC date), but the
DatePart function for example returns 1 instead of 13 for 1 pm. I need
the variable in the 24-hour clock format.
Thanks.
gary@4reach.com Guest
-
How to SELECT DatePart as a new Variable
I need to select the date from a dateTime field as its own variable... for grouping later in the output.<CFQUERY NAME="GetSessions"... -
dateAdd and datePart return 13, 14, 15 instead of 1, 2, 3
I'm trying to increment between the end of lunch and the end of the day. The code below is returning a datePart of 13 instead of 1 (for 1:00:00 PM)... -
DatePart query
Hi Group, i am trying to use the DatePart function on my SQL2000 database. I have a table called visitors with a field called DateTimeEntrance... -
when hour = 01 do
The_Duck wrote: man cron man crontab Chris Mattern -
Using DatePart and DateDiff together in a query
Does any one know how I would go about using DatePArt and DateDiff in the same query for the same field? For example, I need to get the amount of...
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
