datatype for storing dates

Hi,
What is the datatype for storing dates? DATE datatype is not working.... I wanted to insert the joining date of an employee into the table...

Newbie Poster

10 posts since Oct 2007

Reputation Points: 10

Solved Threads: 0

Hi, What is the datatype for storing dates? DATE datatype is not working.... I wanted to insert the joining date of an employee into the table...

It will have to work...
Try again withproper careation of the table

Newbie Poster

2 posts since Nov 2007

Reputation Points: 10

Solved Threads: 1

EDIT: Sorry, missed the "Solved" label.

Light Poster

48 posts since Jul 2007

Reputation Points: 10

Solved Threads: 3

This question has already been solved

You