Jump to content
Interroga

How to write datetime variable in SQL?

Recommended Posts

Hi guys,
we need help for write data in SQL table , for build report. We  don't be how type for use this variable. I try string (all types), but not work.
In anexx my table where need write .

Thanks in advance.

Producao_Colunas.JPG

Share this post


Link to post
Share on other sites

This will enter the date of the insert, not the date from the local datastruct.

Good question because we need this also...  we need a timestamp value in a locak table structure.   Maybe the string format YY:MM:DD HH:MM:SS will work?

 

Share this post


Link to post
Share on other sites

Brother, below is the answer:

INSERT INTO `Alarm`    \\    table adress
(`DateTime`, `User`,`Event`,`Coment`)  \\ column
VALUES(STR_TO_DATE(@DateTime,'%d/%m/%Y %T'), @User, @Event, @Coment )

 

  • Upvote 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...