Search DaniWeb - timestamp

timestamp help? 17 Years Ago by danarashad Please help I have been trying to insert a timestamp field into a DB. But to no avail. Here's … DB set up is. Column name of time. type is timestamp. When I insert i receive an error. thats all it… timestamp 16 Years Ago by srpa01red … a csv file.now i want to insert the current timestamp while loading the data i.e the present time at… loading the data .is it possible to insert the current timestamp while loading the data in the field created_at Re: timestamp help? 17 Years Ago by shovels Why not just add a timestamp to the SQL statement? I would also try to avoid … Re: timestamp 16 Years Ago by nav33n [quote] is it possible to insert the current timestamp while loading the data in the field created_at [/quote] Yes. Use [url=http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_now] now() [/url]. date() doesn't work. Timestamp 17 Years Ago by nigel_h I need to write a shell script to check a file timestamp and if it has not been modified within 30 minutes, kill a process and restart process. Can anyone help Timestamp 16 Years Ago by toolbox03 How do i print timestamp to a text file? any sample codes? Re: Timestamp 16 Years Ago by jephthah … * fp; char stamp[32]; unixTime = time (NULL); fprintf (stamp,"timestamp: %ld\n", unixTime); if (fp = fopen("myfile.txt… Timestamp event in c# .net 14 Years Ago by sodevrom … txt file. Each row of the txt file contains a timestamp hh:mm:ss,mmm (example: 00:05:33,141).… it's not efficient. I would need something like a timestamp event (not using Timer). Any suggestions/code samples? I …Example: event(double time,DoThis) . If time is equal to timestamp, than execute function DoThis. Can someone help? Thanks! Re: Timestamp Today 13 Years Ago by cwarn23 Use the following: [CODE]<?php $timestamp='1318245850'; if (mktime(0,0,0)<$timestamp) { echo $timestamp.' is today.'; } else { echo $timestamp.' is not today.'; }[/CODE] Timestamp php variable into javascript 15 Years Ago by nonshatter … code is me adding a number of days to a timestamp to find out the expiry/target date for the counter… test WHERE id = '1'"); $result = mysql_fetch_assoc($query); $time = $result['timestamp']; $length = $result['length']; echo $time; //PRINTS 2010-04-30 22… Re: Timestamp event in c# .net 14 Years Ago by finito Psuedo code for no code. [CODE]if (readline.substring(get the time stamp).equals(timestamp)) DoSomthing();[/CODE] Re: Timestamp event in c# .net 14 Years Ago by sodevrom … precise). I am going to calculate the difference between the timestamp of the next record and the current time, and start… Re: Timestamp php variable into javascript 15 Years Ago by BeachyUK No problem. date() will deliver the current local time according to the server if you don't supply a timestamp. e.g. [CODE]$now = date('m/d/Y G:i A');[/CODE] Re: timestamp based encryption 12 Years Ago by Ketsuekiame … it with the same key. So unless he transmitted the timestamp across so that the psuedorandom generator could generate the same… number, this would not work. If the timestamp were transmitted, then you've just given away your key… Re: timestamp based encryption 12 Years Ago by riahc3 … it with the same key. So unless he transmitted the timestamp across so that the psuedorandom generator could generate the same… number, this would not work. > If the timestamp were transmitted, then you've just given away your key… Timestamp problems in PHP MySQL 15 Years Ago by whitestream6 …;Episode" Set Reminder[/QUOTE] I can't get the timestamp to set the values as: (value for date and time… Timestamp Today 13 Years Ago by Danny159 Hey, I need some help with working out if a timestamp is today or not... Eg - 1318245850 is Today - 1286709850 isnt today... Dan timestamp not work 13 Years Ago by accra I have time [CODE]timestamp[/CODE] in my db,when i insert/update records it do not change. for Attributes i have [CODE]ON UPDATE CURRENT_TIMESTAMP[/CODE] and for Default its [CODE]CURRENT_TIMESTAMP[/CODE]. any help pls. Re: timestamp not work 13 Years Ago by accra i have fixed it,i was insert/updating a value for this filed, which end up over writing [CODE]timestamp [/CODE] value.thanks for your help timestamp based encryption 12 Years Ago by csss I want to encrypt the data based on user time. Is there any algorithm based on timestamp value for encryption and decryption? Pls give some suggestion Re: timestamp based encryption 12 Years Ago by csss is there any algorithm based on timestamp value? can any one please help me to find out the answer. Re: timestamp based encryption 12 Years Ago by riahc3 > is there any algorithm based on timestamp value? > > can any one please help me to find out the answer. Could you be more specific on what exactly you want to do? timestamp datatype select query 11 Years Ago by jacob21 Hi, I am using timestamp datatype for storing date..and value of column is like 2013-12-31 T 23:59:59.000Z For query SELECT * FROM a WHERE created_on BETWEEN '20131201' AND '20131231' SELECT * FROM a WHERE created_on >= '20131201' AND created_on <= '20131231' Which will give right result?? Re: timestamp datatype select query 11 Years Ago by urtrivedi both will give result but user hyphen 1) '2013-12-01' 2) as yor column is timestamp, it will only give records which are 2013-12-31 00:00:00 any value more then that will not include for same day Following query should work SELECT * FROM a WHERE created_on >= '2013-12-01' AND created_on < '2014-01-01' Re: TIMESTAMP vs DATETIME 14 Years Ago by macobex … want to use timestamp if you will use the datetime value in other country, …. For example, you are in USA and you save the timestamp December 1, 2010 12:20:00 in your database. When… you go to China for example, and you recover that timestamp, it will be converted to China's timezone, so you… Re: timestamp 13 Years Ago by Majestics Target Field is TimeStamp time stamp is storing the data in format of dd-mm-yyyy hh:mi:ss.f , i dont want .f i just want upto seconds... I tried both systimestamp and current_timestamp. Re: timestamp 13 Years Ago by debasisdas If you do not want time factors, why use timestamp for the field. If only data and time portion is required why not use DATE data type and [B]sysdate[/B] only. Re: timestamp help? 17 Years Ago by ShawnCplus What is the error? do this [inlinecode]mysql_query($sql) or die(mysql_error());[/inlinecode] It will tell you the error Re: timestamp help? 17 Years Ago by danarashad thanks i've got it fixed, i just used the now() function Re: timestamp help? 17 Years Ago by shovels Cool, glad I could be of help.