Search Results

Search found 6836 results on 274 pages for 'leap year'.

Page 143/274 | < Previous Page | 139 140 141 142 143 144 145 146 147 148 149 150  | Next Page >

• MySQL grouping by a previously declared alias, what do I wrap it in? ' OR `

  - by cgmojoco

  I have an SQL query that has an alias in the SELECT statement SELECT CONCAT(YEAR(r.Date),_utf8'-',_utf8'Q',QUARTER(r.Date)) AS 'QuarterYear' Later, I want to refer to this in my group by statement. I'm a little confused...should I wrap this with backticks, single quote or just leave it unwrapped int he group by GROUP BY `QuarterYear ` or should I do this?: GROUP BY 'QuarterYear' or just this?: GROUP BY QuarterYear

  Read the article

• Introducing a teenager to webdesigning

  - by phenevo

  Hi, My eleven year brother want to be webdesigner/webmaster and I wonder how to help him with this? What books you recommend ? What soft is good for start ? Maybe incomedia and photoshop ?

  Read the article

• How To Read C# Code From Java Background

  - by ChloeRadshaw

  I come from a Java background and have been using C# for the last year - So far the API docs I use are at MSDN (http://msdn.microsoft.com/en-us/library/ms132397.aspx). I tend to use the lightweight C# docs. What annoys me about that is that I don't see one page with details of the class, a list of members, a list of methods and properties like I would with a Java API definition. Is this possible?

  Read the article

• Is the sIFR project dead?

  - by Sonny

  I need to implement a typographic solution, and was about to go the sIFR route, but sIFR 2 is ancient and sIFR 3 doesn't appear to have been worked on in over a year and a half.

  Read the article

• Rails cookies not working right

  - by Michael Waxman

  Rails is setting and returning a remember_token cookie like this: = cookies[:remember_token] = value6c69b17681d2bf316f8eexpiresThu Jun 10 14:55:00 -0400 2010 In other words, when I'm calling the cookie I don't just get the value. Why is this? I am setting the cookie as follows: cookies[:remember_token] = { :value => @user.remember_me, :expires => 1.year.from_now} What's going on here?

  Read the article

• Is Java worth learning in my late thirties? [closed]

  - by bobi

  Hi guys. First I want to say is that I am 37 years old and not from programmer background (actually from biology). And my question is should I start learning java? I have coded in php and javascript for a year and a half. Every answer would be appreciated Thanks in advance Bobi.

  Read the article

• Side-by-side comparison of data by month in SQL

  - by ScottR

  I have table similar to the following: Year | Product | Value 2006 A 10 2006 B 20 2006 C 30 2007 A 40 2007 B 50 2007 C 60 I would like a query that would return the following comparison Product | 2006 Value | 2007 Value A 10 40 B 20 50 C 30 60 What are the options to do so? Can it be done without joins? I'm working with DB2, but answers in all SQL types would be helpful.

  Read the article

• How to trim minutes and hours and seconds from Date object?

  - by Roman

  I need to make map where Dates are keys. 2 date objects are equals if they have the same value of getTime() method. I'm interested only in year, month and day. How can I trim unnecessary hours and minutes to get 'clear' dates?

  Read the article

• need a help regarding android 1.5 and 2.1 (beginner)

  - by piemesons

  I am new to android and last year i bought two books of android 1.5. But at that time i was busy in my project so was not able to work on android. Now i want to start android again. Should i go for those books or should i buy new editions Is there any major change regarding basic learnings? Please let me know. Thanks

  Read the article

• Summarize Data with SQL statement

  - by bugbug

  I have CMS table that contain CMS_STARTTIME and CMS_STOPTIME (attachment). I want to create report to summarize exist data by using Date, Time and Year as Parameter (attachment). I don't know how to create sql statement to meet this requirement. I'm using MySQL and MS-SQL. Does one can help? Thank you very much.

  Read the article

• is there a faster way to check if this is a valid date ?

  - by ooo

  is there a faster way then to simply catch an exception like below: try { date = new DateTime(model_.Date.Year, model_.Date.Month, (7 * multiplier) + (7 - dow) + 2); } catch (Exception) { //This is an invalid date }

  Read the article

• how to group MySql rows based on month?

  - by understack

  I've a table with a datetime (format: 'Y-m-d H:i:s') 'created' field and 'amount' (integer) field in each row. Now I want to find out total 'amount' in last year month wise. How can I do this? EDIT I made an edit to clarify the actual problem.

  Read the article

• spliting the string

  - by prince23

  hi, i have an string like this string strdate =@"5/2/2006"; which is in a form of month/day/year i need to display it in a form of like this 02-05-2006 how do i format the data like this if the value is like this 12/28/2005 it should be displayed like this 28-12-2010 i know we should be splitting the data based on that we should do it. i am not getting the syntax how to do it . any help would be great

  Read the article

• How to round a time down to the nearest 15 minutes in Ruby?

  - by Readonly

  Is there an easy way to round a Time down to the nearest 15 minutes? This is what I'm currently doing. Is there an easier way to do it? t = Time.new rounded_t = Time.local(t.year, t.month, t.day, t.hour, t.min/15*15)

  Read the article

• parse localtime in c++

  - by Crystal

  Is there an easy "beginner" way to take the current time using to a Date object that has int month int day int year for it's member variables? Thanks.

  Read the article

• Mysql : should i put my data into 1 table or split per user?

  - by Haroldo

  This data is for a holiday cottage's simple accommodation calendars. The data is simple and stores dates when each cottage is booked. The cols would be cottage_id, booked_from_date, booked_until_date and I would expect around 60 rows per user per year * 200-300 users. I should put this is one table right?

  Read the article

• calender Extender problem

  - by picnic4u

  In Asp.net project the Calendar Extender function is working well in IE but not In Mozzila,Crome etc. that property is, when we click on top of the calendar then it open the more option for the year and month selection.

  Read the article

• mySQL convert varchar to date

  - by Jeff V

  I need to convert a varchar value of 1/9/2011 to a date in mySQL and I want only the month and year. So that I can then use the PERIOD_DIFF function (so I would need the above to be converted to 201101). I've tried various ways using the STR_TO_DATE function: SELECT STR_TO_DATE(CYOApp_oilChangedDate, '%m/%Y') FROM CYO_AppInfo But I get weird results... (for example: 2009-01-00) What am I doing incorrectly?

  Read the article

• basic differences between oracle and SQL Server?

  - by I__

  i am going on a job interview and have zero experience with ms sql, however i have 1 year with oracle. is there such a huge difference between the two? what programming questions can i expect?

  Read the article

• Javascript function to add X months to a date

  - by George

  Is there a built in equivalent to the .NET framework's DateAdd or AddMonths functions? I'm looking for the easiest, cleanest way to add X month to a Javascript date. I'd rather not handle the rolloing over of the year as done here. or have to write my own function as done here. Is there something built in that is as nice as the .NET Date.AddMonths function? Or something close?

  Read the article

• PHP number range menu from array

  - by Julious

  Hello people! I'm a bit confused here. I have a php array like this Array(2010,2009,2008 ...1992) and i want to create a loop to print a menu with a four year range counting down like this 2010-2006 2005-2001 2000-1996 etc.. How can i do this Everything i tried end up in an endless loop. THnx in advance. J.

  Read the article

• How do I create new variables based on the size of a List?

  - by GK

  I have a List with say size n, and i have to dynamically create n variables ie i want to dynamically create the variables depending upon the size of the list. How can i achieve this? Say i have List as List year with n elements in it; then i have to create the n Integer variables from the above list. thanks.

  Read the article

• Yet another div height question

  - by cf_PhillipSenn

  Over the years, I've struggled with this. This year, there might be a solution. I need a header, content and footer. I would like the footer to be at the bottom of the page, the header at the top, and the content in between. I would like the content to have a scroll bar. Q: Is that too much to ask?

  Read the article

• JDBC delete statement with multiple columns

  - by user1643033

  It says I ended this statement wrong when if I input it into sql plus with just the addition of ; it works perfectly. What am I doing wrong? Statement statement = connection.createStatement(); statement.executeUpdate("delete from aplbuk MODEL = '"+ textField_4.getText() + "'AND year = '" + textField_1.getText() + "' AND Litres = '" + textField_2.getText() + "' AND ENGINE_TYPE = '" + textField_3.getText() + "'"); statement.close();

  Read the article

• Rails date format in form field

  - by Jack

  Hello I'd like my dates in the mm/dd/year format in text fields. However, they currently displays as 2010-03-26. Is there a global setting I can set to change this? I tried the following, which seems to update the .to_s method, but form fields stay the same. ActiveSupport::CoreExtensions::Date::Conversions::DATE_FORMATS.merge!(:default => '%m/%d/%Y') Thanks

  Read the article

< Previous Page | 139 140 141 142 143 144 145 146 147 148 149 150  | Next Page >