With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf
Solved
Update "yyyy" to "2013"
Posted on 2013-01-10
I have a Microsoft Access query where I am trying to update the "yyyy" "2012" to "2013". Here is the Select query:
SELECT Format([MyDate],"mmyyyy") AS Expr1
FROM Company_Data
WHERE (((Format([MyDate],"mmyyyy
SELECT Format([MyDate],"mmyyyy") AS Expr1
FROM Company_Data
WHERE (((Format([MyDate],"mmyyyy
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
- +2
6 Comments
Active today
I'm not sure I understand the question. Wouldn't you just change it to:
SELECT Format([MyDate],"mmyyyy") AS Expr1
FROM Company_Data
WHERE (((Format([MyDate],"mmyyyy
SELECT Format([MyDate],"mmyyyy") AS Expr1
FROM Company_Data
WHERE (((Format([MyDate],"mmyyyy
Try this
Update Emp_Detail
set Emp_Detail.[JoiningDate] = CDate( Format(Emp_Detail.[Joining
where year(Emp_Detail.[JoiningDa
In your case for year
Update Company_Data
set [MyDate] = CDate( Format([MyDate], "MM/DD/") & "2013" )
where year([MyDate]) = 2012
Update Emp_Detail
set Emp_Detail.[JoiningDate] = CDate( Format(Emp_Detail.[Joining
where year(Emp_Detail.[JoiningDa
In your case for year
Update Company_Data
set [MyDate] = CDate( Format([MyDate], "MM/DD/") & "2013" )
where year([MyDate]) = 2012
if the field is date, you just want to add 1 year:
dateadd("year", 1, your_date_field)
and eventually format from there.
if it's not datetime, it would be about time to think about getting that changed ..
dateadd("year", 1, your_date_field)
and eventually format from there.
if it's not datetime, it would be about time to think about getting that changed ..
Active 2 days ago
If your field is stored as TEXT (not optimal), you can use the following:
Select Query:
Update query:
Select Query:
SELECT Replace([MyDate], "2012", "2013")
FROM Company_Data
WHERE Right([MyDate],4) = "2012"
Update query:
UPDATE Company_Data
SET [MyDate] = Replace([MyDate], "2012", "2013")
WHERE Right([MyDate],4) = "2012"
Featured Post
We will be discussing what Azure Stack is, how does it fit into the suit of offerings that Azure has currently, and where can it fit into your organizations technology stack. We will also be discussing limitations of the platform while covering various applicable scenarios.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Confronted with some SQL you don't know can be a daunting task.
It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as:
(+) as used in Oracle; *= =* as used in Sybase …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month6 days, 9 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.