Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date type problem

Status
Not open for further replies.
jkjkjk

jkjkjk

Programmer
Aug 10, 2003
3
US
when i create a table with "birth_date date()" or "birth date(6)" mysql says that there is a sql syntax error. what's wrong?
 
Sort by date Sort by votes
wht is the query ur giving?

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.
 
Upvote 0 Downvote
that's it! thanks, i'm a rookie at this.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
function argument value, type or count is invalid
Replies
3
Views
358
bharons
bharons
Darryl Johnson
  • Locked
  • Question
Adding labor hours to a date time field
Replies
5
Views
205
Andrzejek
Andrzejek
C_C_K
  • Locked
  • Question
subqueries with multiple date results
Replies
4
Views
323
C_C_K
C_C_K
spamjim
  • Locked
  • Question
Converting JDE Julian date to Gregorian date in SELECT statement
Replies
1
Views
192
spamjim
spamjim
fpalero
  • Locked
  • Question
mysqldump using where clause with current date or date range
Replies
1
Views
249
ChrisHirst
ChrisHirst

Part and Inventory Search

Sponsor

Back
Top