date

Update 2nd Textbox Based On Popup Calendar Selection

I am using the JavaScript-based popup calendar from dynamic drive named "Xin's Popup Calendar" and it works perfectly. But, I want to be able to adjust the date of a 2nd textbox based on the selection. For example, I want to be able to automatically adjust it to +1 month of whatever date was selected in the popup. How can I do that? H...

Julian date to normal date

Hello, Is there any way to convert a 6-digit julian date to a normal timestamp in Postgres? Date is created using python's datetime.toordinal(). For example, >>> date = datetime.date(2010, 7, 20) >>> datetime.toordinal(date) 733973 What I need is to convert '733973' back to '2010-07-20' in Postgres. Thanks! ...

Need a method to convert a date from server's timezone to user's timezone

I need a method which could convert a given date from one time zone to another. Something like: Date Format: 2010-07-13 12:34:00 $newDestinationDate = $convertTimeZoneDate($dateTime, $serverTimeZone, $userTimeZone) Please help? ...

Javascript: How do I convert a specific timezoned date to different time zone date?

I have a php script which gives server time, but as per knowledge, we can get the user's machine time and time zone with the help of client side scripts (javascript). I have mysql table which has dates stored along with timezone from where it was stored with the help of form. I need to show the data on a web page along with the time stor...

Interpreting various date formats automatically

I've got a bunch of old spreadsheet data with date fields. Sometimes I'm lucky enough to get the standard Excel date format, but other times a range of dates was entered, with little consistency in the format: some are 07/2-5/95, others 07/02/1995-07/05/1995, still others 7-2 & 5-95. Short of writing regular expressions and parse rules f...

get week of year from day of year

Given day of year, how can I get the week of year by using Bash? ...

NSDateFormatter problems between versions 10.4 and 10.5

Hey there everyone! I'm creating an app that needs to run on 10.4 and above. Having a date string that is formatted properly is crucial. When I run my program in 10.5 debug everything is good; I get a date which is exactly how I want it: Jul 13, 2010 16 the 16 being the hour without the minutes, which I specifically need. Then when ...

What exists in terms of a Java 'timeline' library?

I am interested in any library which can do the following: I have a time range: let's say 1995 to 2010 which I can classify in some way, let's say as "The Internet Era". I then want to be able to break that up further, say 2001-2010 as "The Google Era". Ideally, I'd like the time line to exist as some sort of list of timespans object...

getThirdMondayInJanuary(): Not working

I need to get third monday in january. I am trying this is javascript **@guys who commented: I was trying to implement this. <script type="text/javascript"> $(document).ready(function() { $('#holidayDate').datepicker(); var availableTags = ["New years Day", "Martin Luther King Day", "Groundhog Day", "Valentine's Day", "Wash...

Custom date format from Linq to SQL query

Im using the folowing function to return a SelectList. I need a custom format on Descr, but replacing Key.ToString() to Key.ToString("DD/MM/YY") render me the error "Method 'System.String ToString(System.String)' has no supported translation to SQL.". How could i use a custom date format on Descr? Public Function ReturnDates(ByVal P...

javascript holiday validation

i finished it <script> Number.prototype.pad = function(n) { for(var r = this.toString(); r.length < n; r = 0 + r); return r; }; function getThirdMondayInJanuary(year) { var d = new Date(); if (year) d.setFullYear(year); d.setMonth(0,15,0,0,0,0); // 15th of Jan d.setDate(d.getDate()+([1,0,6,5,4,3,2][d.getDay()])); //get nex...

Problem with Javascript Date function in IE 7, returns NaN

I have a twitter feed and I create a new date obj so I can format the date to my liking. var created = new Date(this.created_at) works in firefox and chrome but not in IE7. I seem to be having trouble passing the date through the new Date() function. It just returns undefined and NaN. Here is the code. If you try to test it out don't ...

converting to YYYYMMDD format with the value date posted from php

I have a date value posted from php using jquery (MMDDYYYY)and i want to convert this date format to YYYYMMDD using php . $fromDate=str_replace("'","''",trim($_POST['tx_fromDateDsp'])); echo "-->".$year = substr($fromDate, 6, 4)."<br>"; echo "-->".$month = substr($fromDate, 0, 2)."<br>"; ...

Parsing date from Calendar in Java

Hi, I am having following function public static Date parseDate(String date, String format) throws ParseException { SimpleDateFormat formatter = new SimpleDateFormat(format); return formatter.parse(date); } I am using this as follows in my code Calendar eDate = Calendar.getInstance(); eDate.add(Calendar.DAY_OF_MON...

is there a tricky way to optimize this query

I'm working on a table that has 3008698 rows exam_date is a DATE field. But queries I run want to match only the month part. So what I do is: select * from my_big_table where to_number(to_char(exam_date, 'MM')) = 5; which I believe takes long because of function on the column. Is there a way to avoid this and make it faster? other ...

Calculating Number of Months between 2 dates

I have the following VB.NET Code: Dim Date1 As New DateTime(2010,5,6) Dim Date2 As New DateTime(2009,10,12) Dim NumOfMonths = 0 ' This is where I am stumped What I am trying to do is find out how many months are between the 2 dates. Any help would be appreciated. ...

Convert mm/dd/yy to mm/dd/yyyy in PHP

I'm working on a project that requires me to read values from a file and manipulate them slightly before storing them elsewhere. One of the things I need to do is convert some dates from mm/dd/yy format to mm/dd/yyyy format. Unfortunately for me, I am relatively new to PHP and regular expressions (which I assume is one of the better ways...

How to validate Date object in Java

Hi, Can any one tell me solution for the following: I have a Util.Date object in java.I want to validate the date entered. I am parsing the date object using the required format. For ex, Format is "MM/dd/yyyy" and Date entered is "23/12/2010" For this date, I am not getting any Parse Exception but the date is adjusted to "11/12/2011" wh...

String to Date Parsing not working

I am getting date as string as a parameter from Servlet. Now when I am trying to parse it again to get util.Date, it gives me error. I am getting string "Fri Jul 02 00:00:00 IST 2010" & I want util.Date from it. Tried SimpleDateFormat, DateFormat but didn't work. ...

C# How to get the date mouseover with a DateTimePicker?

I want to add a tooltip to the DateTimePicker Calendar that show some informations based on the date that the mouse is over. Is there a way to retrive the date under the mouse without clicking it? ...