Ask Your Question
0

How to autofill the date in a database table [closed]

asked 2014-03-08 00:29:39 +0200

Slow Motion gravatar image

I've created a small Database and would like each record date stamped automatically when it's created. I just can't figure it out. I was even looking for a way to write the function CURRENT_DATE or some variation as an autofill field but can't figure out how to do it. Thanks for any help

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 06:56:50.968610

2 Answers

Sort by » oldest newest most voted
0

answered 2014-03-08 02:57:11 +0200

m.a.riosv gravatar image

updated 2014-03-08 02:57:45 +0200

edit flag offensive delete link more
0

answered 2015-09-12 06:31:16 +0200

babak7 gravatar image

Mariosv's answer is correct as his youtube video demonstrate very well. I specially liked it because the video was in Spanish and I am learning Spanish and I was supersized that I could understand the video without any problem. The only thing I need to add is that if the column , Ie. the field, is already created, you can use following line instead of the line he is using in the video. Here is my attempt to say this in Spanish: Si ya se ha creado el field, puede utilizar la línea siguiente:

 alter table "Table1" alter  COLUMN "Date" TIMESTAMP default now
edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-03-08 00:29:39 +0200

Seen: 3,916 times

Last updated: Mar 08 '14