[date] Forum Topics

Allright. It's me again. :D This time, I'm making an alarm clock program. I've already completed the bit that gets and displays the system time: Date vrijeme = new Date(); int sati = vrijeme.getHours(); int minuti = vrijeme.getMinutes(); int sekunde = vrijeme.getSeconds(); Also made a method that compares that time …

Hi All, I've tried the following to format my date in 'dd/mm/yyyy' instead of 'dd/mm/yyy hh:mm:ss' when importing data from csv to DataSet. CONVERT(VARCHAR(10), [dateColumnName], 103) AS [DD/MM/YYYY] and CONVERT(DATETIME, [dateColumnName], 101) AS [DD/MM/YYYY] Both give me the error: Undefined function 'CONVERT' in expression What would be the correct method …

Hi need some help suggestion I am trying to search data form two date range but it seems not working properly when i search for $from_date = "2013-04-01"; $to_date = "2013-04-04"; $query = mysql_query("SELECT * FROM date WHERE Date between '" . $from_date . "' AND '" . $to_date . …

<?php $startdate = date('Y-m-d H:i:s'); echo $startdate."</br>"; $offset = strtotime("+1 day"); $enddate = date("Y-m-d H:i:s", $offset); echo $enddate."</br>"; $newamount = $availablequantity - $quantity; if($enddate > $startdate) { if($availablequantity != 0) { $sql = mysql_query("UPDATE size SET quantity ='$newamount' WHERE id ='$item_id'") or die (mysql_error()); } //$sql = mysql_query("UPDATE size SET …

Please help. I can't get my calendar to automatically get the current date. I'm not sure where the problem is so I'll post the whole script. Here it is. (function($){ var availableTags = [ "ActionScript", "AppleScript", "Asp", "BASIC", "C", "C++", "Clojure", "COBOL", "ColdFusion", "Erlang", "Fortran", "Groovy", "Haskell", "Java", "JavaScript", "Lisp", …

I have two fields in table, (i) section_from & (ii) section_to, both fields has Date datatype, these fields tells us that this law section is enforced From(section_from) this date To(section_to) this date. The problem is, the latest law sections (active law) which are issued by the government has no specific …

Hi, I need to exclude any rows where the ASX_Prices.Date is a weekend. The date format is yyyy/mm/dd 2013/03/17. Ideally I would like to add another WHERE clause. WHERE ASX_Prices.Date !=weekend date????? $sql="SELECT Distinct ASX_Prices.ASX_Code, ASX_Prices.ASX_Price, ASX_Prices.Date, Company_Information.Company_Name FROM ASX_Prices, Company_Information WHERE ASX_Prices.ASX_Code = Company_Information.ASX_Code AND DateDiff(now(), ASX_Prices.Date)<=7 ORDER BY …

Hi friends Please help me it is out of my head, I am pussing date and other variables value through url. Some time date is entering correctly in date field and some time entering 000-00-00. Please help me out. <?php include '../require.php'; $date=mysql_real_escape_string($_REQUEST['id']); $app_id=$_REQUEST['app']; $branch=$_REQUEST['branch']; $ins=$_REQUEST['ins']; $ins=$ins+1; //echo $app_id; //$rr="select …

Hello , I had this question how to make your calendar recognize a date and how to make by example change your backgroundcolor when it is the 31 october (halloween) if you can answer this question , please do it! thx

I would like to make a program in which the user selects a time frame, for example if he selects from a DateTimePicker1 the time 7 (July), 17th, 2012 through DateTimePicker2 7 (July), 20th, 2012, and presses the button, a text will show up in a textbox from which he …

Its all in the title, i want to get 2 dates from user then view them in a data report text labels so we have idea what the report is displaying

Hi, Im trying to get the depreciation value of an equipment every month. My system gets the number of months from date of purchased up to current date for the computation of depreciation. I can run the report anytime but the computation must be like this: Sample: Date purchased January …

I am looking for a Date picker (dd/mm/yyyy), which is support in all browser. Is any one provide me the code in JavaScript.

I have got around 10 <div>'s and in every <div> there is a different datetime. I want to call a java-script function when the clients local time matches the time in that <div>'s. //sample scenario <div id="a" class ="help">2/3/2013 6:39:14 PM</div> <div id="b" class ="help">2/3/2013 2:39:14 PM</div> <div id="c" class …

Hi guys, I'm working on a holiday scheduling app and I was wondering that if a person wants his holiday for example 10 days. id uid data1 data2 ore tip_concediu ts 7 244 2013-01-25 2013-02-05 3 2 2013-01-25 16:08:35 How would it be possible that I could track the holiday …

hi, i have a table in database that contains birthday column varchar()- i choose varchar because ecoder could input birthday like 1. 1993-14-03 2. 1993-03-14 3. March 14 4. March 14,1993 5.etc.... Now my problem i want to detect what month is their birthday could some help me?

Hi, I let say I use this code to retrieve date from database SELECT Table.Date FROM Table The format is 01/09/2013 (dd/mm/yyyy) How will i format this to get 09-Jan-2013 output then print this format to crystal report? I'm using dataset to connect data to crytal report I just noticed …

I have a time as a string saved as HoursMinutes example 1642 (16:42) and I tried to convert it to date as Hours:Minutes with following code: Dim dt As Date Dim s As String s = "1642" dt = CDate(Format(s, "00:00")) but the result is: 00:00 instead of 16:42 Any …

> Hi guys, how to get **date modified** document in process upload? ex: test.txt 30/11/12 02:13 how to get this date **30/11/12 02:13** while upload this document? > i've try like this but the result not matching with real date modified $filename = $_FILES['uploadedfile']['name']; echo date("d m Y H:i:s",filemtime('/' . …

Hello, please am having issues querying my reports from the database. i want to creat a reports from a number tables ( rooms ==> this table is where i have all the room numbers. bookings ==> this table is where i have all the room numbers used per each date. …

Hi, is there any API for historical dates on web that returns data in xml or json format. For example, I need to get importants events in history on todays day and show that events in my app. Is there any good place to do it? And if you know …

Hi, I am creating a program that will validate if the user input date is correct. My problem is checking the month, 1. Is it possible to save the all the months in an array and then check the array if the user input is correct. 2. How can it …

I'm having a strange issue that I'm sure has a reasonable answer, but it's making me nuts. I am using the code below, but no matter what I do, on the host's server it displays the created_date as '0000-00-00 00:00:00'. I get the correct response locally. If I go to …

WHERE Category = '" + CategorySorter.Text + "' AND DateAdded = '" + DateValue("DateEnd.Text") + "' " thats my query and its not working, if the user input a date(like this 12/25/12) in DateEnd.Text, i want to confirm if it is existing on a database

hi, i want to check a specific date using if condition. i want only date, not month and year. like code checks only date 20 of every month when i clicked a button. please help me....

Hello to everyone, im having trouble in inserting a date like "2012-12-06" into a database mysql, Im using phpmyadmin+wamp and adobe dreamweaver!I want to use 3 textfields, one for the year, other for the month and a last one for the day, but I always get an error by using …

Hi Folks, I'm brand spankin' new to developing but was assigned a web app to develop in ASP.NET 4 with C#. I am using JavaScript for validation. The problem I'm having is that the date validation alert box that pops up displays a lot of unneccesary time and timezone information, …

I'm not sure why I suck so bad at this. I was recommended by my prof to use date as opposed to timestamp. I'm starting to think going back to timestamp would be easier due to built in php functions I can use. so in my original addproduct.php form I …

Hello all: I have the following mysql query statement: SELECT COUNT(*) as ttl_rows FROM (SELECT DISTINCT(date(timeentry)) AS day, COUNT(*) AS total FROM history where MONTH(CAST(timeentry as date)) = MONTH(NOW()) AND YEAR(CAST(timeentry as date)) = YEAR(NOW()) GROUP BY DATE_FORMAT(timeentry, '%d') ASC) as ttl_row the statement performs a search for all records …

Hello Developers, I am a beginner in python and need help with writing a regular expression for date and time to be fetched from a html document. In the following code I am walking through the html files in a folder called event and printing the headings with h1 tag …