Formatting Date to make counts easy.

Hi, I having a problem doing a simple count with the way date is format 2005-12-11 21:49:36, what I am wanting to do is a simple count where it only returns just the date. What do i need to do to get it where is (2005-12-11) and for that matter switch the date to us format. Here the sql

Re: Formatting Date to make counts easy.

on 12/15/05 4:51 PM, Payne at [EMAIL PROTECTED] wrote: Hi, I having a problem doing a simple count with the way date is format 2005-12-11 21:49:36, what I am wanting to do is a simple count where it only returns just the date. What do i need to do to get it where is (2005-12-11) and for

Re: Formatting Date to make counts easy.

Payne wrote: Hi, I having a problem doing a simple count with the way date is format 2005-12-11 21:49:36, what I am wanting to do is a simple count where it only returns just the date. What do i need to do to get it where is (2005-12-11) and for that matter switch the date to us format.

Re: Formatting Date to make counts easy.

Thanks, this and the from ISC Edwin Cruz helped, it what I was wanting. Payne Sameer wrote: Payne wrote: Hi, I having a problem doing a simple count with the way date is format 2005-12-11 21:49:36, what I am wanting to do is a simple count where it only returns just the date. What do i