Question : I have a DB with a table which has a column datetime Date_Time. The format of this is […]
Tag: date-format
Incorrect value for str_to_date
Question : I’m running a simple procedure that reads from a VARCHAR column and inserts data into a TIME column, […]
Storing date as integer (numeric), what are the advantages
Question : Question 1 I am working with a system where date is stored as integer (actual numeric(8,0)) and I […]
Create table using select statement Truncated incorrect datetime value:
Question : I have looked up different answers on similar question before posting it here. So i have a table […]
How to cast (a) a date value recorded as a VARCHAR to (b) a specific DATE format for (c) use in an ORDER BY clause
Question : How would I cast a column value (a “non-MySQL” DATE string retained as a VARCHAR) to a “MySQL […]
Compare a date and a timestamp with time zone with now() in the same query?
Question : I have multiple database servers I’m querying with a query that compares an expiration column with now(). The […]
Having performance issue for an extract date without time to compare with sysdate,
Question : I need to get all the rows where its ‘time’ field is equal to sysdate. The thing is […]
Decode query truncates a date
Question : I am not sure if I am looking at this problem the right way: I have a query […]
Does SQL Server have a Date_Format function?
Question : All I found is a list of predefined DateFormat that I can choose from, like this As I […]
How to pass, specific day month and year in the below query?
Question : I have registration according to the data in a table and I want to show the whole month, […]