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

  • Whether you're wondering if the title of "developer" should have your name next to it or you've just started on the path to software success, consider this guide your personal README.md file. (And if that reference didn't make sense to you, read on. It will soon, grasshopper.) This software developer resource guide explores just how in-demand developers are and the growing gap of qualified individuals needed, discusses the many benefits and perks of being a developer, and enlightens you on the myriad of …

  • Today's trend towards digital transformation has produced a shift from monolithic, purpose-built, network packet brokers (NPB) to software-driven, off-the-shelf hardware platforms based on merchant silicon. Software-driven packet flow visibility solutions are more flexible, scalable, and cost-effective to deploy, and, ultimately, also enable software innovation. This white paper describes how the latest generation of multicore processor x86 server platforms can further reduce the cost and increase the …

Most Popular Programming Stories

More for Developers

RSS Feeds

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