Skip to content
Advertisement

Tag: date

Is there a way to change DATE format on?

I need to store some date in my SQL database, the problem is that the default storage is And I need My only solution was to store date as Varchars (10) and it’s working pretty well, but now I can’t order my queries by DATE, and I need to order them from the oldest to the newest… Answer There is

Return value at max date for a particular id

Here’s my sql server table This seems like it should be easy to do, but I don’t know why I’m stuck. I’d like to select ONLY the max(date) and value at that max(date) for each id. I want to ignore all other dates that aren’t the max(date) with respect to each id. Here’s what I’d like the table to look

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….

java.sql.SQLException: ORA-01843: not a valid month

I am getting the following error when inserting data into my oracle database. In database date is as: dd-MMM-yy (06-MAR-12) I am converting 06-03-2012 to dd-MMM-yy by the following method: So i got 06-Mar-12 which is same as the above database date format still i am getting the error. I am inserting as: in index.jsp in servlet(doPost) Any idea please

Selecting by month in PostgreSQL

I want to select rows according to the month of a date or timestamp column like this: But I only get error messages in PostgreSQL. How can this be done? Answer You can use EXTRACT function, like this: Your problem comes from the fact that there is no such thing as Month function in PostgreSQL. Check online documentation here to

Get DateTime with time as 23:59:59

I’m trying to do a where statement that specifies a DateTime field is between the start and end of the previous month. To do this, I need to specify that the first day of the previous month has a time of 00:00:00 and the last day of the previous month has a time of 23:59:59. This second condition is giving

Get the 2 digit year in T-SQL

I need to get the current 2 digit year and increment by one. So the current number I’m looking for should be 11. Probably really simple but I’m a sql noob 🙂 Thanks Answer You can do ( YEAR( GETDATE() ) % 100 ) + 1 See GETDATE & YEAR

Group by date range on weeks/months interval

I’m using MySQL and I have the following table: I want to be able to generate reports like this, where periods are done in the last 4 weeks: or in the last 3 months: Any ideas how to make select queries that can generate the equivalent date range and clicks count? Answer

Advertisement