When your day-to-day work includes a lot of document editing, you realize that every file format needs its own approach and often particular applications. Handling a seemingly simple WRI file can often grind the whole process to a stop, especially when you are attempting to edit with inadequate software. To prevent this sort of troubles, get an editor that will cover all your requirements regardless of the file extension and join date in WRI with no roadblocks.
With DocHub, you are going to work with an editing multitool for any occasion or file type. Minimize the time you used to invest in navigating your old software’s features and learn from our intuitive interface design as you do the work. DocHub is a streamlined online editing platform that handles all your file processing requirements for any file, including WRI. Open it and go straight to productivity; no previous training or reading manuals is required to reap the benefits DocHub brings to papers management processing. Start with taking a couple of minutes to register your account now.
See improvements within your papers processing just after you open your DocHub account. Save your time on editing with our one platform that can help you be more efficient with any document format with which you need to work.
[Music] well write a circle query to find a joining date of employee in this format so we want a year of joining to be displayed in four digits then month of joining to be displayed in uh three characters and date of joining to be displayed in two or digits right so uh let me show you through an example so here im going to select basically uh employee name that is another e name then here im going to use a two car function to basically display joining date in this format right so im going to copy this guy then here im going to select uh basically column name is called higher date right and here im going to specify which format i want our joining there to be displayed and lets give the column alias as higher date higher date right from emp thats it let me format this query and if i run this query then here you can see uh this is the employee name and this is the date of joining which has been displayed in the format of four digits of year of joining then three digits three char