Editing date field in SQL

190 pts.
Tags:
SQL
SQL statements
Can we edit date field in SQL select statement?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    What do you mean by edit? Change the format from mm/dd/yy to yy/mm/dd or the actual data?Are you looking to validate the date to make sure nobody enters a date like 02/30/2017?
    115,270 pointsBadges:
    report
  • Subhendu Sen
    If you use select query directly data field modification is not possible. But if you are asking for update, that is possible. However, more information is needed that what actually you want like update/alter. Also if this is a business case, please come back with your query that can helpful to us.
    119,980 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: