sql Archives - Page 28 of 45

When I select date in SQL it is returned as 2011-02-25 21:17:33.933. But I need only the Date part, that is 2011-02-25. How ...

The UPSERT operation either updates or inserts a row in a table, depending if the table already has a row that matches the ...

What is a “stored procedure” and how do they work? What is the make-up of a stored procedure (things each must have to ...

My current query looks like this: SELECT * FROM fiberbox f WHERE f.fiberBox LIKE '%1740 %' OR f.fiberBox LIKE '%1938 %' OR f.fiberBox ...

I have a table that is a collection entries as to when a user was logged on. username, date, value -------------------------- brad, 1/2/2010, ...

I have a SQL script that has to be run every time a client executes the “database management” functionality. The script includes creating ...

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

I want to extract just the date part from a timestamp in PostgreSQL. I need it to be a postgresql DATE type so ...

I need to convert a value which is in a DateTime variable into a varchar variable formatted as yyyy-mm-dd format (without time part). ...

I have a SQL column with a length of 6. Now want to take only the first char of that column. Is there ...