date

insert date in a word document

Hi everyone, I'm working on a Word document which has a table on each page. Each table contains several occurrences of the word "Datum". By doubleclicking this word "Datum", this word should be replaced with the system date. And this date should be "frozen", i.e. it mustn't adapt itself when opening the document on a different day. ...

What is causing this difference between my Ruby on Rails console output and my Firebug console output when using a Ruby date object?

Can anyone explain the difference between the Ruby on Rails console output and the Firebug console output? event_controller.rb def list_events @days[1][:date] = (((Date.new(2010, 8, 6)) + 1).to_s) end list_events.html.erb <% @days.each_with_index do |day, i| %> <% p day[:date] %>; //RoR console console.log(<%= day[:date]...

Determine if Oracle date is on a weekend?

Is this the best way to determine if an Oracle date is on a weekend? select * from mytable where TO_CHAR (my_date, 'DY', 'NLS_DATE_LANGUAGE=ENGLISH') IN ('SAT', 'SUN'); ...

Adding a link on every date in jQuery plugins: datepick

Hi, I would like to add links on every date in my calendar. For example, if I click on the 25 august 2010, I would like that the page gets redirected to : xxxxxx/25082010/ (ddmmyyyy) The plugins is this one : http://keith-wood.name/datepick.html I can add an event when a date is selected (onSelect) but I can't get the date in the goo...

Add milliseconds to Java date, when milliseconds is long

Hi guys, I am looking for the best way to add milliseconds to a Java Date when milliseconds is stored as a 'long'. Java calendar has an add function, but it only takes an 'int' as the amount. This is one solution I am proposing... Calendar now = Calendar.getInstance(); Calendar timeout = Calendar.getInstance(); timeout.setTime(toke...

How to select records grouped by the hour of the day including hours that have no records

I have a table in an Oracle database that contains actions performed by users in one of our systems. It's used for statistical analysis and I need to display the number of actions performed for a given date, grouped by hour of the day. I have a query that does that fine, however, it does not display the hours of the day that contain no ...

Comparing dates and times in different formats using Python

I have lines of the following format in a file. Summary;meeting;Description;None;DateStart;20100629T110000;DateEnd;20100629T120000;Time;20100805T084547Z I need to create a function that has two inputs: time and date in the following formats Time: HH:MM and date as mmddyyyy. (These are strings). Now the function needs to read this line...

Format date like: Monday, 1st March

Seems like it should be simple enough but it's driving me up the wall. I've looked at the python date formatting strings and it still doesn't make too much sense. Here's what I'm trying to do: <Full day>, <Day of month><Ordinal> <Month> Where <Ordinal> is st, nd, rd, th, etc depending on the day. ...

Is there a good way to get the date of the coming Wednesday?

Is there a good way to get the date of the coming Wednesday? That is, if today is Tuesday, I want to get the date of Wednesday in this week; if today is Wednesday, I want to get the date of next Wednesday; if today is Thursday, I want to get the date of Wednesday in the following week. Thanks. ...

I am trying to convert a date/time string in PHP

I am trying to convert a date/time string in this format YYYY/MM/DD/HH:MM:SS to a format that is recognized in PHP ...

mysql date to php

I have a date field in mysql that contains numbers like 2455419. Any idea what format this is and how to convert to php/human eadable form? ...

string to php timestamp

Possible Duplicate: convert any date string to timestamp without timezone I have a string that looks like this and want a php timestamp format. I can ask client to change format of the string if necessary. 2010/08/11 06:33:00 ...

Only one expression to get the Date of yesterday and the first day of month

Hi i am using a reporting tools which only support one line expression By example I want to get the Date of yesterday the class Calendar has a add method, but it returns void so Calendar.getInstance().add(Calendar.DAY_OF_MONTH,-1).getTime() didn't work don't know how to get this done Thanks ...

comparing current day of Date type with Varchar day column in Oracle

I have a Varchar day column and I would like to select all rows where the day from day column matches current day in the system. I came up with this query but it didn't find any match, although today is Thursday and there is Thursday stored in the day column. I'm not sure if this is the right way to compare date data type with varchar. ...

JPA 2.0 Oracle DATE has null time

Hi everyone, This seems like such a bonehead question, but I've been chasing my tail around a tree all day. I have a Struts 2 + Spring3/JPA/Hibernate application that inserts a large set into the DB. In the set is a Java util date. I've checked the date just before the Dao inserts the rows and all the dates have the correct times. After...

why strotime returns negative value in php?

Hi, I am using strtotime to convert a date to a unixtime stamp. Year, date and day comes as different values to code and I am using the below code to produce the timestamp. $year = '1961'; $month = '2'; $day = '15'; $date = $year."-".$month."-".$day; echo strtotime($date); The above code prints : -27648000 for me. If the year ...

"pretty print" duration in java

Hi folks, Does anyone know of a java library that can pretty print a number in milli seconds in the same way that c# does? E.g. 123456 ms as a long would be printed as 4d1h3m5s (might not be accurate , but you see hopefully what I'm getting at!!) -ace ...

How do I get the day month and year from a Windows cmd.exe script?

How do I get the current day month and year from inside a Windows cmd script? I need to get each value into a separate variable. ...

PHP / MySQL - determine a series of dates based on a start date + INSERT

Hello I would like to produce a list of dates based on a user determined "start date", over a 12 week period. If a user selects today's date, I need to know each date from today over 12 weeks. Once I have these dates, I would need to insert them into a DB table. I'd like to say I've made some in-roads into how to do this, I reckon ...

How do I calculate the date difference?

How to calculate the date difference in Android? ...