Forums Register Login

Can't select current Date, time or datetime

+Pie Number of slices to send: Send

I come up with this on my own, but I don't get why this doesn't return any rows
just success.
+Pie Number of slices to send: Send


Taking one step further, but this returns syntax error with the VALUES keyword
Any help please.
+Pie Number of slices to send: Send


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
What's that smell? I think this tiny ad may have stepped in something.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1128 times.
Similar Threads
Get only date in a select statement
java.text.ParseException
sql query for set column pair values
comparing dates in db2
RichFaces calendar: how to get ID from ondateselected event?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 10:43:25.