I am trying to get transaction counts for every hour. Normally it is a straight forward query by unfortunately the timestamp column I have to work with is not timestamp but varchar2! No matter what I try I get either “not a valid month” or “invalid number”, depending on the format I us…
Tag: date-format
Convert Timestamp to MYSQL Date In Query usable in WHERE
I am working with a MYSQL database where the developer has stored the date as a timestamp instead of a ‘datetime’ field that can be queried. The following query creates an ‘AS’ field date_formatted and the output is correct. However that field cannot be used in a WHERE statement to lim…
Date format is not working in some computers, SQL Query
Below date format is not working in some computers I do know why, I use SQL Query. What is the problem? Please anyone can help me Answer I tried to convert variable instead of converting in SQL Query
DB2 Date format
I just want to format current date into yyyymmdd in DB2. I see the date formats available, but how can I use them? http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm….