SQL DateTime functions

 Return Current date in SQL

SELECT GETDATE();

Return the current UTC date and time:

SELECT GETUTCDATE();

Get the month of date

SELECT month('2017/08/13 09:08') AS DayOfMonth;

Get the Year of Date

SELECT YEAR('2024/11/24 09:08') AS Year;

Get Month Name 

SELECT DATENAME(month, GETDATE()) AS monthname;

Find the Weekdays as today

SELECT DATENAME(WEEKDAY, GETDATE()) AS DatePartString;

Add a year to date & return the date: 

SELECT DATEADD(year, 1, '2024/09/25') AS YearAdd;

Subtract 2 months from  date & return the date:

SELECT DATEADD(month, -2, '2024/09/25') AS MonthSub;

Get the difference of month 

SELECT DATEPART(day, DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE())+2,0)))

Get the End of month date

SELECT DAY(EOMONTH(GETDATE()))

Get only todays date and month

select convert(varchar(5),getdate(),110)

Adobe ROBOHelp

1. What is Robo Help?

RoboHelp is a popular Help Authoring Tool (HAT) from Adobe.

It contains, Knowledge Base article, help contents, e Learning sources.

RoboHelp created by Gen Kiyooka and released by Blue Sky Software in 1992. It is acquired by Adobe in 2005.

2. RoboHelp Layout Support

RoboHelp can output to different formats using the following Single Source Layouts (SSLs)

• Responsive HTML5
• eBook
• Microsoft HTML Help
• JavaHelp
• Oracle Help
• Eclipse Help

3. Workspace Overview

4. Creating a Project

5. Creating Topics

• Topic creating the content for such as Text, Video and Images. You can see all the project contents on below path.
• Click on the Contents and than Assets.

6.  Add New Contents

You can add new contents by clicking to the  + icons.

7. Publishing contents

You can see the output  In browser

Create first Github Action

 What is Git hub action?

It use for continues integration and continues deployment,  There are certain criteria it need to full fill and do the quality check before this deployment of code that can be happen by github actions.

Github Action Terminology

Workflow : it  is an Yml file, it contains:

• Events
• Job
• Runners
• Steps
• Actions

Github Action Events

• Events are trigger for workflow, common events like some one pushes the code into the repository.
• When the events occurs, it will run all the jobs mentioned into the workflow.