Hello everybody. There is a row in my db table I have set it's type as "TIMESTAMP". How should I fill in? Should get the current timestamp in php and send it to that row, correct? So how can I do that?

Member Avatar
Member Avatar
+0 forum 5

Hello, I have one query with timestamp. I got below error. select users.login, FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(ticket_history.create_time)-UNIX_TIMESTAMP(ticket.create_time))) from ticket_history_type inner join ticket_history on ticket_history.history_type_id=ticket_history_type.id inner join ticket on ticket.id = ticket_history.ticket_id inner join users on users.id = ticket_history.change_by where ticket.create_time BETWEEN '2014-10-01' AND '2014-10-15' AND ticket_history.name ='%%new%%Fermeture réussie%%' group by users.id *`error: function unix_timestamp(timestamp without time zone) does not exist`* Thanks in advanced for your input.

Member Avatar
Member Avatar
+0 forum 8

HI can any one please help me how to convert timestamp to IST jtime = 2014-07-23 02:41:05 to Date H:i:s am/pm formate

Member Avatar
Member Avatar
+0 forum 1

Hi, I am a beginner at programing and I have to do this project where it is asking me to valid ISBN 10 and 13 using MySQL database to store the information. I checked my php code to validate ISBN 10 and 13 and it works, but when I try to store the data to MySQL it is not working. What I mean is that when I click ShowISBN link it doesn't show this information: Please go to this site to check my code because when I post my code here Iget the following message: The code snippet in your …

Member Avatar
Member Avatar
+0 forum 2

I have a code that places the time into a database in the format Year-Month-Date Time. The time isnt in Pm or Am. I want to change the code from that into Month/Day/Year and the time in am or pm. Is this possible? Or should I be using a different method to placing the date into the database?

Member Avatar
Member Avatar
+0 forum 5

Hi I have just replied on a post that was posted 43 years ago. My reply was also 43 years ago. I had that feeling that time just flies lately but this might be a little too fast. Or is it just some issue with unix time. This is the link to the article. http://www.daniweb.com/web-development/php/threads/461757/feedback-system-phpmysql#post2008638 EDIT: it is back to normal. I was just extremely lucky to whitnes this extraordinary event for a very short time.

Member Avatar
Member Avatar
+1 forum 8

I have a CTE based query, to which I pass about 2600 4-tuple latitude/longitude values using joins - these latitude longitude 4-tuples have been ID tagged and held in a second table called coordinates. These top left and bottom right latitude / longitude values are passed into the CTE in order to display the amount of requests (hourly) made within those coordinates for given two timestamps).- I am able to get the total requests per day within the timestamps given, that is, the total count of user requests on every specified day. (E.g. user opts to see every Wednesday or …

Member Avatar
Member Avatar
+0 forum 1

Sorry people but I'm really struggling with this and I don't know why... but still. I have a stored unix timestamp. [a] I have the current timestamp not in unix format (YYYY-MM-DD HH:MM:SS) [b] I need to: 1) convert the current timestamp [b] into a unix timestamp 2) I need to take the stored timestamp away from the newly created timestamp 3) I need to add the converted timestamp onto the stored timestamp. This is for an uptime counter that uses days hours minutes and seconds, not %. Thanks :)

Member Avatar
Member Avatar
+0 forum 1

I'd like to add a timestamp to articles I upload to my website, which reads the time and date the article was uploaded. I've got a database, as well as a working connect.php. In this database, I've created a table with a "date" field (type: date). What can I do to get the timestamps working?

Member Avatar
Member Avatar
+0 forum 10

I know little PHP, but even less MySQL, and my host doesn't allow remote database connections (for example, from Dreamweaver), so in addition to being confusing to me, database management is impractical. Is there any way to put a timestamp on an article automatically, without resorting to MySQL tables?

Member Avatar
Member Avatar
+0 forum 2

I need to add dynamic timestamp with the attachment file test.dat as (test_currentDateTime.dat) sample code which I need to modify: <node name="testEmail" type="emailoutput" subject="this is a test mail with an attachment" xsl="&XSLPATH;test.xsl" outputType="text/plain" > <attachment type="text/plain" name="test.dat"/> </node> How can this be done in the attachment tag that is inside the node tag in xml. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 3

I've just started working with PHP, and one of the first things I want to do is add a timestamp to my article template in Dreamweaver, so that each article I post automatically has the post date. How would one go about doing this?

Member Avatar
Member Avatar
+0 forum 1

Hi, When a user registers on my site there status is 0 (not active) ... meaning they not activated there account via email. When they register i also store the DATETIME they registered, i store it in MySQL using MySQL DATETIME and using `NOW()` in my INSERT query on registration. Format stored as: `0000-00-00 00:00:00` . I want to be able to delete everything from `users` table where `status = 0` (not active) and where a user has not activated there account within 48 hours. My MySQL query so far is: SELECT * FROM users WHERE user_status = 0 AND …

Member Avatar
Member Avatar
+0 forum 11

Any file's primary header contains some things which are common to all operating system like entry point function, time stamp etc and then other things. What is the purpose of keeping this time stamp in the header. Thanks

Member Avatar
Member Avatar
+0 forum 4

In writing a logger for an application, the datestamp ends up adding a new line. The datestamp function is as follows: [CODE]string log_class::get_time() { time_t rawtime; time (&rawtime); string timestamp; timestamp = (ctime (&rawtime)); return timestamp; } [/CODE] This outputs something like [ICODE]Tue Sep 6 14:58:35 2011[/ICODE], but when called in the main function with [ICODE]logfile << get_time() << " " << logmessage_to_write << endl;[/ICODE], it produces a newline after the datestamp like: [CODE]Tue Sep 6 14:58:35 2011 data goes here[/CODE] I would like it to be on one line, as in [ICODE]Tue Sep 6 14:58:35 2011 data goes here[/ICODE], …

Member Avatar
Member Avatar
+0 forum 5

Im creating a time-base site wherein the timestamp should rely on the global time and not to my PC's time (because it can be out-dated somethimes). How can I do that?

Member Avatar
Member Avatar
+0 forum 8

I built a quick date time test page. The coding is below followed by its results. I'm entering the raw timestamp into table time because i want to be able to manipulate it once i show it (say if i want to show time and date using the same timestamp). Let me know what i'm doing wrong. Thanks datetest.php [CODE] include 'config2.php'; $dbname = 'time'; $tablename = 'time'; include 'opendb.php'; $name=$_POST['name']; $date= date("g:ia"); $timestamp=time(); mysql_query ("INSERT INTO $tablename (timestamp,name) VALUES ('$timestamp','$name')"); $res = mysql_query("SELECT timestamp, name FROM time ORDER BY timestamp DESC;"); while ( $row = mysql_fetch_array($res) ) { $timestamp …

Member Avatar
Member Avatar
+0 forum 4

Ok I'm trying to build a forum site. I have multiple tables representing the different categories that the user can select from. I'm working on the head page and what I want to do is retrieve the 10 last most recent comments posted across all tables. I want to use the time stamp that I have created BUT i'm not sure if i'm using the most efficent coding to record time. This is what I'm using. [CODE] $tablename='sports'; $topic=$_POST['topic']; $comment=$_POST['comment']; $username=$_POST['username']; $date= date("M jS, Y"); $time= date("g:ia"); mysql_query ("INSERT INTO $tablename (topic, comment, username, date, time) VALUES ('$topic','$comment','$username','$date','$time')"); [/CODE] Is …

Member Avatar
Member Avatar
+0 forum 7

I have these strings as $remaining_time: "3h5m" "4h9m" "15m" "17h" "6d17h" What I want to do is be able to parse through them and output the results in unix format so I can add them up to my $start_time (in unix timestamp) to get the end time. Any suggestions how I can do this? Thanks. John

Member Avatar
Member Avatar
+0 forum 4

Hi, I need to get the UNIX timestamp from when the day started in AS3. How can I do this??? Thanks in advance :)

Member Avatar
Member Avatar
+0 forum 2

The End.