Date query

Hopefully your database field is a date datatype and not a character datatype. If it is not, do something about it, storing dates as text is a horrible idea.

To insert data, do not worry about format. All you need is a datetime object. The cold fusion createdatetime function might come in handy.

When format does matter is when you are displaying the data. There is at least one, and maybe two ways to do this. The first is with the dateformat and timeformat functions you already know about. The second would be with database functions, depending on the database.

cybertek23 wrote:
> Hi,
>
> I know this is a really easy thing but i can not get this working properly
> today. I need to put a date into a database. I need the date to display in in
> the following format 20/09/2007 13:16:34 (dd/mm/yy hh:mm:ss). I need the time
> to be the 24 hour clock. I jsut cant get this to work. Please help
>
Use the dateFormat() function for the date part and the timeFormat()
function for the time portion. Note: for a 24 hour/military hour
display use 'HH'. This is one place in CF where case matters 'hh' is 12
hour and 'HH' is 24 hour display.

You can use the TimeFormat function on your date field.

Lookie here