ATL Date Routines

WEBINAR: On-demand webcast

How to Boost Database Development Productivity on Linux, Docker, and Kubernetes with Microsoft SQL Server 2017 REGISTER >

Environment: Visual C++ 6 (SP3)

When writing ATL components, one of the hardest things to overcome for Windows programmers, in my opinion, is the dependency on the MFC library. For dates and strings, MFC simplifies the programmer’s job by handling memory allocations and type conversions within its class encapsulation. However, with that simplification comes the price of having to distribute the MFC DLL’s with your component.

This article focuses on the issues surrounding the use of dates within an ATL component. I developed the DateLib component as part of a project for my company and, as such, the methods of this component are specific to my company’s requirements (I do not have an intellectual property agreement with this company). However, the DateLib component does illustrate how to build an ATL component that has no MFC dependencies, is thread-safe, and will compile as either ANSI or UNICODE.

The methods within the DateLib component are as follows:

Date Formatting Routines

  • Now - Returns the current system date in a DATE variable.
  • OLE2Oracle - For a given DATE, returns a formatted string using the DD-Mon-YYYY representation.
  • Int2Oracle - For a given month, day, and year, returns a formatted string using the DD-Mon-YYYY representation.
  • Int2OLE - For a given month, day, and year, returns the date in a DATE variable.
  • OLE2String - For a given DATE, returns a formatted string using the MM/DD/YYYY representation.

Date Parsing Routines

  • ParseOracle2OLE - For a given date given in a M/D/YY format, returns the date in a DATE variable.
  • ParseOracle2String - For a given date given in a M/D/YY format, returns a formatted string using the MM/DD/YYYY representation.
  • ParseOracle2Oracle - For a given date given in a M/D/YY format, returns a formatted string using the DD-Mon-YYYY representation.

Date Math Routines

  • GetFirstDay - For a given DATE, returns the first day of the month in a DATE variable.
  • GetLastDay - For a given DATE, returns the last day of the month in a DATE variable.
  • GetNextDay - For a given DATE, returns the next day’s date in a DATE variable.
  • GetNextWeek - For a given DATE, returns the next week’s date in a DATE variable.
  • GetNextMonth - For a given DATE, returns the next month’s date in a DATE variable.
  • GetNextYear - For a given DATE, returns the next year’s date in a DATE variable.
  • GetPreviousDay - For a given DATE, returns the previous day’s date in a DATE variable.
  • GetPreviousWeek - For a given DATE, returns the previous week’s date in a DATE variable.
  • GetPreviousMonth - For a given DATE, returns the previous month’s date in a DATE variable.
  • GetPreviousYear - For a given DATE, returns the previous year’s date in a DATE variable.

Downloads

Download demo project - 4 Kb
Download source - 31 Kb


Comments

  • There are no comments yet. Be the first to comment!

Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • On-demand webcast Continuous integration and continuous deployment (CI/CD) allow DevOps teams to be more efficient. When starting from a production environment, the use of Microsoft SQL Server 2017 in Docker containers and Kubernetes clusters can facilitate a DevOps CI/CD pipeline. Using SQL Server tools also allows you to easily integrate core DevOps application lifecycle management practices to database development. Watch this on-demand presentation to learn how defining the database dependency as …

  • Testing full recoveries of IT environments requires a proven methodology. Establishing and meeting recovery time objectives (RTOs), configuring a cloud recovery system, and tracking your changing environment are all critical components of a successful cloud recovery operation. It's also important to establish and follow a set of cloud disaster recovery (CDR) best practices. Read this technical guide to learn about these best practices, along with how disaster recovery as a service (DRaaS) can help you complete …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date