SQL to insert Timestamp Data Type into MySQL

A timestamp is a sequence of characters, denoting the date and/or time at which a certain event occurred.

The time at which an event is recorded by a timestamp (e.g., entered into a log file) should be very, very close to the time of the occurrence of the event recorded.

example of a timestamp in mysql : 2010-02-02 18:15:37

How Using SQL to insert Timestamp Data Type into MySQL ?

(Provided Table First)

CREATE TABLE `guest_book` (                                                      
              `id_gb` int(4) NOT NULL AUTO_INCREMENT,                                        
              `pengirim` varchar(20) NOT NULL DEFAULT '',                                    
              `email` varchar(50) NOT NULL DEFAULT '',                                       
              `isi` text NOT NULL,                                                           
              `tgl` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
              PRIMARY KEY (`id_gb`)                                                          
            )

Just Running A Query


insert into guest_book
(pengirim,
email,
isi,
tgl
)
values
('pengirim',
'picas @ unud.com',
'isi',
CURRENT_TIMESTAMP
)

in the  provided table.


And The Result :
Timestamp, MySQL Timestamp, datetime query, log SQL, Catatan waktu SQL, Field Waktu MySQL, Waktu MySQL

Komentar FB


Probably Related Article



104 comments:

rumah blogger said...
February 2, 2010 at 11:22 PM

kelihatannya yg pertamaaxx ya

sabirinnet said...
February 2, 2010 at 11:22 PM

mengamankan yang keduaxx
sukses mas ya

Rackmount Monitor said...
February 3, 2010 at 1:50 AM

Finicky Post! You had a massive occurrence. I am plagued with your illustration. Thanks for giving out your creative mind's eye.

call center said...
February 3, 2010 at 5:03 PM

I would recommend this useful information to anyone because it is really very important to know everyone those want to accumulate an eye on the bazaar trends as that all is done.

Business plan consulting services said...
February 3, 2010 at 9:26 PM

Thanks for clearing this up. You’ve posted some really useful information.

Rackmount LCD said...
February 4, 2010 at 2:33 AM

hi,
thanks for sharing this useful information with us, i am very glad to know more about this topic,and your post will really helpful for me. Keep sharing such a good ideas with us.

crazycoder said...
February 6, 2010 at 9:45 PM

I have a question for you... Time stamp is one data type that stores time and date information... There is another similar one datetime which also does the same work... Is there any significant difference between the two ?

Search Engine Markiting said...
February 6, 2010 at 10:25 PM

Blog is really informative and entertaining same time. I Really appreciate it.Thanks

SHRENIK said...
February 7, 2010 at 6:55 AM

hi friend i saw your blog its really nice even i run a blog www.trickscafe.blogspot.com
i think we shall exchange our links if you are intrested plz comment on my blog trickscafe.blogspot.com or mail me on crazyshrenik@gmail.com

Picas said...
February 7, 2010 at 7:08 AM

@ crazycoder..
The DATE type is used when you need only a date value, without a time part. MySQL retrieves and displays DATE values in 'YYYY-MM-DD' format. The supported range is '1000-01-01' to '9999-12-31'.

For the DATETIME and DATE range descriptions, “supported” means that although earlier values might work, there is no guarantee.

The TIMESTAMP data type has a range of '1970-01-01 00:00:01' UTC to '2038-01-19 03:14:07' UTC. It has varying properties, depending on the MySQL version and the SQL mode the server is running in.

I think no significant difference, except we have been in 2040...

hope this answer your question..

treatment center directory said...
February 18, 2010 at 5:29 AM

I really appreciating this post and information as well, i never seen such type of post and glad to be join this at same time.

micro sd card said...
March 11, 2010 at 9:39 PM

I am It student and now I doing project of on line shopping and this example is useful to me in this project.so thank you for this example.

Rome Hotels said...
March 15, 2010 at 9:59 AM

Hey I was stuck on the same point...and was not able to find out the solution...thanks for solving my problem...Keep up the good work.

Hire ASP Net Web Programmers and developers said...
March 17, 2010 at 1:33 AM

"A timestamp is a sequence of characters, denoting the date and/or time at which a certain event occurred." this is a good short and simple definition of timestamp...thanks for provide a good understanding about the topic...Keep up the good work.

Loyalty Program said...
March 17, 2010 at 5:51 PM

Thanks for sharing your opinion.I am very pleased to read after this superb blog.

Flex programmers said...
March 18, 2010 at 6:46 AM

This useful information to anyone because it is really very important to know everyone those want to accumulate it.I am very glad to know more about this topic,and your post will really helpful for me. Keep sharing such a good ideas with us.

hire drupal developer said...
March 19, 2010 at 12:22 AM

We should thank you for giving such a wonderful blog. Your site happens to be not only informative but also very imaginative too. We find a limited number of experts who can think to write technical articles that creatively. All of us are on the lookout for information on something like this. I Myself have gone through several blogs to build up on knowledge about this.We look forward to the next posts !!

venice Hotels said...
March 30, 2010 at 10:19 AM

This is rally great piece of information. You have explained "timestamp" very well in very simple language. Thanks for the info. I will share the post with others to.

Brand & Logo design said...
April 29, 2010 at 5:43 AM

Its really very nice blog. Thanks for providing such useful information.

Anonymous said...
April 29, 2010 at 9:46 PM

Very interesting post, I really enjoyed reading it.

You have a great site full of very valuable information - I plan on coming back for regular visits.
You can also visit my site to find many Rome Hotels

Hire virtual assistant said...
May 5, 2010 at 12:21 AM

This is very useful information for any sql user.thanks for sharing this typ of information.
Keep it up

PHP programmer said...
May 5, 2010 at 12:39 AM

This is very userfull information for all the people who are from IT company and student also.....

hydranautics said...
May 12, 2010 at 12:37 PM

Really nice review! Unboxing is the best part of getting something! thanks for a nice post.

toronto bathroom renovations said...
May 26, 2010 at 10:26 PM

Really I feel very nice to read this blog. it is very knowledgeable and helpful for me.

Stainless Steel Pipe Fittings said...
June 4, 2010 at 3:44 AM

Honestly speaking it was not that easy for me to make it possible. Without your help. Thanks a lot for providing great help. Keep up the good work.

Database management said...
June 10, 2010 at 6:29 AM

Great stuff!!! Hey the code you have provided here is really very helpful for me. I was stuck on this point and I was not getting any thing good but finally here I got the info. Thanks.

apartments Buenos Aires said...
June 11, 2010 at 9:21 AM

As a regular reader of your blog I'm very grateful for such a good information that you provide every time, mark

mariage Photographes à Paris said...
June 12, 2010 at 4:16 AM

Informative and useful blog that you are sharing and very knowledgeable for the software and IT fields,Thanks for this blog.

Speed Reading said...
June 21, 2010 at 2:40 AM

There are certainly many more details to take into consideration,As a reader, it is really good that i am always learning something but thanks for sharing this post.

Aerial Installation Birmingham said...
June 24, 2010 at 2:24 AM

I am new in this field and I was facing few problems for the same. Thanks a lot for such a wonderful information sharing. Keep up the good work.

yoga e-books said...
June 25, 2010 at 5:53 AM

Nice post with a good article on this post. It is really nice sharing. I am very glad to read this nice article. Keep it up.....

starting solids babies said...
June 27, 2010 at 10:01 PM

Hey that’s a very nice article and I really attract with this article the reason is that I get many information from this article. So thanks for posting me.
http://www.yummum.com.au/whatsnew.php?id=74

best natural mascara said...
June 28, 2010 at 1:38 AM

This is superb.
Thank you for giving such useful information
Thank you for this blog.....
best natural mascara

photographe professionnel mariage said...
June 29, 2010 at 10:49 PM

Fantastic and awesome post,too useful for the developers and it industries,Very informative,Thanks for sharing this blog.

barbaragabogrecan said...
July 1, 2010 at 3:56 AM
This comment has been removed by the author.
Hostess torino said...
July 13, 2010 at 4:14 AM

Nice work thanks for shearing your great article and great blog.
Hostess torino

Agenzie modelle milano said...
July 20, 2010 at 4:38 AM

Best and useful for the IT field sector,nice and informative article, Thanks for giving this blog.

Rewards program said...
July 21, 2010 at 9:26 PM

Omg i should have read this post before my exam. I was struggling at SQL classes. :(

Southampton Internet Marketing said...
July 31, 2010 at 2:51 AM

Excellent information related to the softwars development and informative too, Thanks.

Nashville Party Bus rental said...
August 4, 2010 at 3:26 AM

Excellent and valueable article about the SQL, that is useful as well as important for programming, Thanks.

Permanent Make Up said...
August 11, 2010 at 2:22 AM

thnx for the needful command on SQL to insert Timestamp data type into mysql.
please make available download MySql ser and related commands........
thnx..........!!!

SuckFul.net - Free Website Directory - Link Submit - Web Submission - Websites that Don't Suck! said...
August 12, 2010 at 4:05 AM

Enormous post-- you make so many points that simply make knowledge for me. Thanks for this informative post.

High Pagerank Google PR Link Directory - Transops.Net said...
August 13, 2010 at 5:38 AM

You have prearranged outstanding inspiration here.

Directory Submitter said...
August 13, 2010 at 5:44 AM

Pleasant informative post. Keep posting. This does give us a lot of information. Cheerful posting.

RC Market said...
October 19, 2010 at 4:27 AM

Excellent and impressive work done for the needy people,I really thankful to you and really inspired, Thanks. It’s hard to see this… They need our help and we should help them without any difference…

condo website said...
October 21, 2010 at 2:54 AM

Knowledge giving Article! I appreciate you. I completely agree with you. If we talk about current scenario then it is must be update. I enjoyed reading. I would like to visit more for more queries.

marketing hampshire said...
October 22, 2010 at 4:18 AM

very nice posting submitted by you really it's so nice stories you have inspired me thank.

Toronto Marketing Company said...
December 12, 2010 at 11:29 PM

I'm testing and experimenting for things but I think TIMESTAMP columns are display in the same format as DATETIME columns. In other words, the display width is set at 19 characters, and the format is 'yyyy-mm-dd, hh-mm-ss'.

hire web developer said...
December 30, 2010 at 12:17 AM

hi thanks for this nice and quality information providing effort.

sexy lingerie said...
January 10, 2011 at 12:19 AM

The time at which an event is recorded by a timestamp (e.g., entered into a log file) should be very, very close to the time of the occurrence of the event recorded.

aerial installation birmingham said...
January 12, 2011 at 3:24 AM

Informative post, work with timestamps between sql and php can be pretty tricky especially if you want to convert from us date format to uk date format.

Hire PHP Developer said...
January 13, 2011 at 11:45 PM

Gone with the post the coding mentioned in the post using SQL to insert Timestamps Data Type.

SEO Services India said...
January 20, 2011 at 1:49 AM

Thanks for the usefulful command on SQL to insert Timestamp data type into mysql.please make it available to download MySql server and related commands........
Keep sharing such useful stuff...

website development said...
January 20, 2011 at 3:55 AM

Have you ever thought about adding a little bit more than just your thoughts? I mean, what you say is important and everything. But its got no punch, no pop! Maybe if you added a pic or two, a video? You could have such a more powerful blog if you let people SEE what youre talking about instead of just reading it.

Athletic Training Supplies said...
January 22, 2011 at 4:58 AM

That has dynamic and so creative idea to make a powerful interest in this area. Thank you very much.

property in panchkula said...
January 27, 2011 at 11:03 PM

Fantastic and awesome post,too useful for the developers and it industries,Very informative,Thanks for sharing this blog.

website melbourne said...
February 24, 2011 at 12:35 AM

Suddenly I saw this blog and read it’s comments . good blog and good comments in this blog for top php and mysql. thank you.

Aerials Birmingham said...
March 11, 2011 at 2:35 AM

http://aerial-installation-birmingham.com/digital-signal/aerials-birmingham-0121-314-2777/

Jaz said...
April 29, 2011 at 3:55 AM

Accommodation in hotel is available and welcoming where location is very close to the airport and station.

Pousada Buzios

Joomla Web Development said...
May 17, 2011 at 10:55 PM

This post is really sweetest on this notable topic. I harmonise with your conclusions and will thirstily look forward to your incoming updates. Keep posting good blogs. Thanks.

Ecommerce website developers said...
May 27, 2011 at 4:06 AM

It is really nice to visit your article. I could get lot more knowledge from your article.. thanks for sharing.

Anonymous said...
June 1, 2011 at 3:18 AM

People do not know who will endeavor to help. It is dangerous to speak to the Family who own most Major bugs in the province, his epic peace Anthem But it can not make a Profit.

Roulette Bets

jasa ekspedisi said...
June 9, 2011 at 10:42 PM

yang lagi mau jual kebun sengon mau bagi info nich tentang bibit jabon dan kayu jabon bagi yang suka bertani

jual rumah jakarta selatan said...
June 9, 2011 at 10:42 PM

mampir nich dari jaksel..

domain name registration said...
June 15, 2011 at 6:09 AM

I am not very well know about the the SQL this is first i see this webpage now i am learn more this content of the SQL thanks to sharing the wonderful information it really very good ti increase the my skills level

jackmartin said...
June 29, 2011 at 2:52 AM

it was just informative news and thanks for sharing such a useful information.
- florida beach resorts

register domain name india said...
July 8, 2011 at 4:00 AM

Hi this one is great and is really a good post. I think it will help me a lot in the related stuff and is very much useful for me. Very well written I appreciate & must say good job..

Website Development Company said...
July 13, 2011 at 2:37 AM

thanks for sharing,

payday loans same day said...
July 26, 2011 at 4:02 AM

I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work.. payday loans

ipad keyboard case said...
July 31, 2011 at 6:35 AM

I really think I have much to learn on timestamps issues. Thanks for providing us with some insights.

register domain name said...
August 1, 2011 at 10:31 PM

Great information I am always searching for informative information like this. Thanks for sharing with us.

hire web developers said...
August 4, 2011 at 5:10 AM

This is really a blog worth following. You have got a great deal to say about this subject, and so much knowledge about this. I am glad to know this blog.
hire web developers

hire web developers said...
August 4, 2011 at 5:10 AM

This is really a blog worth following. You have got a great deal to say about this subject, and so much knowledge about this. I am glad to know this blog.
hire web developers

SEO USA said...
August 10, 2011 at 11:50 PM

I dont think this is required, but maybe as the company is the owner they can do anything.
SEO USA | SEO Greece | SEO Dubai

Domain registration said...
August 19, 2011 at 5:05 AM

Good u created a beautiful blog. And it helps us for know all about bloges and how share ideas all the time.

android development said...
August 23, 2011 at 10:18 PM

Thanks for providing this good informative post and i got a good knowledge from your blog, i think most of the peoples are get good benefited from this information.

web design company said...
August 28, 2011 at 9:44 PM

Your blog is outrageous! I mean, Ive never been so entertained by anything in my life! Your vids are perfect for this.
web design company

revitol hair removal cream said...
September 29, 2011 at 1:13 PM

Awesome post admin. I am sharing this right now with my office mates.

Android developer said...
October 3, 2011 at 5:59 AM

This is such a great resource that you are providing and you give it away for free and I will actually delicious it and I'll suggest to my friends.I apperceive they will absolutely be benefited from this site.

Cheap Boats said...
October 19, 2011 at 9:50 AM

Informative and interesting which we share with you so i think so it is very useful and knowledgeable. I would like to thank you for the efforts. I am tiring the same best work from me in the future as well.

Cheap Boats

polycystic ovarian syndrome and infertility said...
November 27, 2011 at 11:42 PM

This is the right blog for anyone who wants to find out about this topic. I think it is very useful and knowledgeable and really appreciate your wonderful knowledge and the time you put into educating the rest of us. Thanks for taking time for sharing this article.
polycystic ovarian syndrome and infertility

crm solutions said...
November 28, 2011 at 4:23 AM

really amazing blog and I was thankful to you for sharing such a useful information.
- CRM Solutions

online website creators hire said...
November 30, 2011 at 10:28 PM

I love your articles. Nicely presented information in this post, I prefer to read this kind of stuff.

Webmail Hosting services said...
December 14, 2011 at 3:59 AM

I have gone though your website and found it very interesting read.. I appreiciate this task for sharing this information. Hope, you keep updating it very frequently.

Top website companies said...
March 15, 2012 at 12:58 AM

I wanted to thank you for this great blog! I really enjoying every little bit of it and I have you bookmarked to check out new stuff you post

Honeywell said...
March 30, 2012 at 4:58 AM

Lots of thanks for this post. I think it is a very good post. It helps us many away. So many many thanks for this article.

Skinny Jeans said...
April 4, 2012 at 7:58 AM

http://www.directfashiononline.com.au
Thank you very much for posting this article. Its a very useful article. We will be acquire lot of things from this site.So i want some information about this post.

resort booking said...
April 9, 2012 at 2:27 AM

it was just informative news and thanks for sharing such a useful information.
- resort booking

fashion website design said...
April 24, 2012 at 11:59 PM

It is a nice article.This site has lots of advantage. I found many interesting things from this site. It helps me many away. So many many thanks for sharing this information.

Solar power for homes said...
May 22, 2012 at 1:48 AM

I am very pleased with your good work. You put really very helpful information. Keep sharing!!

Assignment Help said...
July 10, 2012 at 4:30 AM

Wow It is nice Information. I like it.

indian designer sarees said...
August 15, 2012 at 12:17 AM

hahaha. Nice post. I like this. this is funny. I need to know that is this true or just a post to make laugh? Any ways nice information man.

sending gifts to pakistan said...
September 26, 2012 at 3:56 AM

I feel that this site could be very useful & informative. Looking forward to more stuff

Richard Byrdk said...
November 24, 2012 at 1:14 AM
This comment has been removed by the author.
Laptop Murah said...
September 27, 2013 at 2:36 AM

this post is so fantastic. I really like this. Highly appreciate the author's work. Great job!

Laptop Murah said...
September 27, 2013 at 2:39 AM

Should there be another persuasive post you can share next time

Website Design Company said...
October 16, 2013 at 1:23 AM

Thanks for sharing the SQL code. Very helpful.

Wilson Larrie said...
November 11, 2015 at 10:24 PM

Assignment Homework Help
Thanks for sharing this blog its very informative and useful for us .

Brian Joseph said...
November 12, 2015 at 1:39 AM

I am pretty sure about this information you shared because its really helpful for everyone.
SEO Writing Service

case study said...
November 12, 2015 at 2:05 AM

Analysis Case Study
Case Study Analysis, A case study evaluation needs one to address the company’s issue, analyze the alternate options, and propose the best answer using supporting evidence.

Assignments Provider said...
November 12, 2015 at 2:51 AM

That is fantastic blog, I will pas this to the other peoples.
Social Issues Sociology Help

Mike Jasson said...
November 12, 2015 at 3:26 AM

Accounting Dissertation writing services
yeah it was such an awesome blog that i have updated.. :)

Victor Baily said...
November 12, 2015 at 4:47 AM

Thanks for such a great content on this website. 
Visual Basic Project Help

Architecture Firm said...
September 15, 2016 at 11:52 PM

What’s up, just wanted to say, I liked this blog post. It was helpful. Keep on posting!
Software Development Services USA
best mobile application development services

Related Posts by Categories



Widget by