[timestamp] Forum Topics

If a bulk MySQL insert takes 5 minutes to complete, and one of the columns in the table is a TIMESTAMP column with a default value of CURRENT TIMESTAMP, will the timestamps of the rows that were inserted be reflective of the entire 5 minutes, or will they all default …

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?

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 …

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

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 …

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 …

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 …

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 …

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 …

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 …

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?

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 …

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?

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. …

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

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 …

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?

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). …

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 …

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 …

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