Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Can't select current Date, time or datetime

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I come up with this on my own, but I don't get why this doesn't return any rows
just success.
 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Taking one step further, but this returns syntax error with the VALUES keyword
Any help please.
 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


This is not correct
Error code -1, SQL state 42X04: Column 'type2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'type2' is not a column in the target table.

This has to be something to do with the double quotation marks.
What do I do? the deadline of the project is approaching.
And I've still got heaps to do.
So please help ASAP.
Thanks
Jack
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic