I have a series of dates formatted as: 26/03/1992 12/06/2010 13/01/1995 etc... it's in DD/MM/YYYY. I need to find the day like "Tuesday", "Monday" etc out of them. I know I need to parse the date or something but I'm unsure how to go about this. thanks. ...
I'm sure this is a easy problem, but I just can not seem to find how to do this anywhere. I need to use the current Date and save it into a String. I do not know how to get the dat stamp. Could someone please help me out? Thank you for your time! -Jeff ...
How do I format a date in a korn shell script to DD-MON-YYYY? I have tried the following: date '+%d-%h-%Y' It returns 04-Nov-2009 I need for the Nov to be NOV (all caps). Can this be done with the date utility? ...
hi foks, i am facing issue while creating table where in that one column which is set to default value of current date........i would stress this point "that i need only date not time along with that"....i would be really thankfull to those who tries to help me.... ...
Howdy, I have a Microsoft Excel 2003 file that I am querying from C# 2.0 using an OleDbConnection. One of the cells in the Excel file is formated as a short date and displays in Excel as "1/1/2009". If I change the format to General the text displayed in that cell changes to "39814". If I query the Excel file while the file is op...
I have an HTML page with a web form. Among other things, it includes the following form fields: Title - textbox SourceName - textbox Url - textbox FullText - textbox PublicationDate - textbox using jQuery datepicker UI StartDate - textbox using jQuery datepicker UI EndDate - textbox using jQuery datepicker UI I am trying to implement...
What is the best way to retrieve the current date? Currently I am storing the date like this: string date = DateTime.Now.ToString("yyyyMMdd"); Obviously, if the user changes the date on their system, this will also be affected. I need a way to access an accurate date (preferable in central time) and store it as a string within my ap...
I'm looking for help in writing a script to find the next available time slot. Ex: Person A wants an appointment and the available time slots everyday is 9am, 12pm, 4pm, 6pm, 9pm So, I need to check existing data and compare the time slots booked for the other appointments and then find next available. $apts = array( 'Person ...
I'm using PHP to validate form input before the form data's submitted to a MySQL database. What would be the best way to validate a form input for the year only? I have a form input where users should input a date, in the form of a year only. Obviously I can check that the input's numeric and has only 4 characters, but what would be the...
I'm trying to CREATE a TABLE with an attribute of type DATE in Microsoft SQL Server 2008. However, when I execute the query, I get the error: Column, parameter, or variable #3: Cannot find data type DATE. I consulted the documentation, and it indicated that DATE is a valid type in SQL Server. It works if I replace "DATE" with "DATE...
Hi, I've been using strtotime("$day-$month-$year"), in my app and it works cool... but know I want to make some date comparisons still in this format but I'm not sure about what is precise, It's as if any format goes ...
How can I get the last day of the month in PHP? Given: $a_date = "2009-11-23" I want 2009-11-30; and given $a_date = "2009-12-23" I want 2009-12-31. ...
I'd like to get an 'end date' from a given 'start date' in PHP. End date is based off the start and are calculated as follows: If Start date is from the 1-15th of the month, End date is the 15th of the following month. If Start date is from the 16-31 of the month, End date is the last day of the following month. eg: $start_date = '20...
Hi. I was wondering if anyone would help with the following: I have a date called into a function in php. I need to estrapolate the month form this date in order to make some calculation base on the month only. I really have no idea how do go about it. I have tried few things but none works. It there anyone who can give a clue? Appre...
Hi I have already asked a similar question. but want to make a change like this: I have a starting date and ending date called into a function in php. I need to estrapolate the stating day and month form the startingDate and the same for the endingDate, so to make calculation based on day and month. How do I go about this? Thank you th...
Sometimes I have a datetime or timestamp columns in the database and, for example, I need to select all records with timestamp updated today. I usually do it like this: SELECT * FROM mytable WHERE CAST(TS AS DATE) = CURDATE(); SELECT * FROM mytable WHERE CAST(TS AS DATE) = '2009-11-01'; Also, it's possible to use DATE() function ...
I need some help with the following: I am setting up a booking system (kind of hotel booking) and I have inserted a check in date and a check out date into database, how do I go to check if a room is already booked? I have no clue how to manage the already booked days in the database. Is there anyone who can give me a clue how this wor...
I'm confused as to where I can find the date a youtube video was uploaded. I've been using the following two functions: $videoEntry->getUpdated()->getText(); $videoEntry->getVideoRecorded() The first is when the video was last updated, and I'm not so sure that is the same as when it was uploaded. The "video recorded" is not always pre...
I have a UIDatePicker that well, allows you to select a date (not time). I then save this NSDate and use display it in a label on a different view. However, when I load back the view with the UIDatePicker, if the user has already selected a date, I want it to show that selected date (using NSDefaultPrefs). How do I do this? I know how t...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(DATE, GETDATE()) SELECT * FROM MySQL2005LinkedServer.SomeDB.dbo.SomeTable WHERE SomeDatetimeField < @MyDate I get this error: OLE D...