Please help an absolute beginner.

Am creating a table that contains a date in mm/dd/yyyy format. Have used
all kinds of combinations on 'date DATE('mm/dd/yyyy')' and am getting
nowhere. What am I doing wrong?

TIA

In article <IWDln.9186$NH1.3084 (AT) newsfe14 (DOT) iad>, frank says...
Date data is not stored using a particular format, it is simply stored as
a date data type. In can be extracted from the database and then
displayed in a particular format if you wish.

Geoff M

On Wed, 10 Mar 2010 14:09:24 +1100, Geoff Muldoon wrote:

Thanks. Just tried the field as date Date and the thing works just
fine.

Thanks again.

On Wed, 10 Mar 2010 02:59:52 GMT, frank wrote:
Is it stored in a date column? Or a character column of some kind and
you need to SUBSTR it out?

--
It is impossible to sharpen a pencil with a blunt axe. It is equally
vain to try to do it with ten blunt axes instead
--E.W Dijkstra, 1930-2002

On Wed, 10 Mar 2010 08:51:28 -0600, Peter H. Coffin wrote:

I was going to store it in a DATE column, but you are right. I may be
better off storing it in a string of some sort. The DATE seems to work
for me now.

frank wrote:
Generally, if you want a date, store it in a DATE column. There are
multiple functions available to extract the date in the format you wish.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On Wed, 10 Mar 2010 15:32:25 GMT, frank wrote:
uhm, other way around. I wasn't advocating storing it in a string; I'm a
great believer in using DATE for dates.

But you sounded like you were having trouble getting something to
display how you wanted it to from something else, and I was asking what
it was right now so that we could get you to what you want.

--
Either way, it'll remind the clued that there's only one letter
difference between 'turkey' and 'turnkey'.
-- Mike Andrews