473,406 Members | 2,549 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

How can I insert the system date into a table?

How can I use the below query in an INSERT query?

SELECT to_char(SYSDATE, 'DD/MM/YYYY HH24:MI:SS') FROM DUAL;
#

Example:

INSERT INTO X (
1,
12,
SELECT to_char(SYSDATE, 'DD/MM/YYYY HH24:MI:SS') FROM DUAL;
)
Oct 7 '11 #1
1 5719
debasisdas
8,127 Expert 4TB
If the target field is of date data type then you can directly user this.

Expand|Select|Wrap|Line Numbers
  1. INSERT INTO X (1,12,SYSDATE); 
Oct 10 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Reshmi Jacob | last post by:
Hello, Can any one help me in creating a trigger to update system date into a table while inserting a record into that table. I tried it like this, it is showing error !!! The following...
1
by: technocraze | last post by:
Hi guys, I am having trouble resolving this error. Below mentioned is my code and implmentation. MS Acess is my front end and sql server is my backend. What i want to achieve is to be...
2
by: sourabhmca | last post by:
Hi Friends, I am creating an application in JSP and MSSQL, In MSSQL I took a table there is one field cdate smalldatetime.it take system date by default.but now i want to display record according to...
7
abouddan
by: abouddan | last post by:
Hi all I am trying to insert in my table "Table1" a new record. This table contains a field "cDate". When using a form to insert in that table the textbox "txtDate' is filled automaticly (row...
1
by: arunjyoti | last post by:
I was going to make a simple program for calcualting one's age. I have made it . The user have to insert his date of birth and also current date(today's date).. but i want to calculate it...
2
by: Louverril | last post by:
I have a problem I just can't get any sort of query findfirst or the sql below to correctly compare a value in a table with a supplied value. I created a very simple situation to try and figure ...
3
by: kanimozhiz | last post by:
Hi I am trying to insert the data in the DB(sql server2005) using the dataset. I was trying to insert the data using the stored procedures.The problem is I am unable to insert the 'date' in the...
5
by: thecheyenne | last post by:
Hi there and happy new year to all of you. I've been reading the thread "Auto Date in form "pages" from 'frys' in the topics and his/her problem is similar though not identical to mine. Here is my...
3
by: gsreenathreddy | last post by:
Hi! I would like to insert the date in specified format in DB, the date type is Date Type, I am using the following queries to insert the data 1) INSERT INTO EMP VALUES (1, 'red', 'CLERK', 2,...
3
by: buterfly0707 | last post by:
hi ... assume computer system date format is mm/dd/yyyy but the format which SQL is getting dd/mm/yyyy. and from the c# code by sql query i have to convert the date to sql datetime format to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.