Regenerate session id in asp.net

protected void ReGenerateSessionId()

        {

            SessionIDManager manager = new SessionIDManager();

            string oldId = manager.GetSessionID(Context);

            string newId = manager.CreateSessionID(Context);

            bool isAdd = false, isRedir = false;

           

            manager.RemoveSessionID(Context);

            manager.SaveSessionID(Context, newId, out isRedir, out isAdd);

            HttpApplication ctx = (HttpApplication)HttpContext.Current.ApplicationInstance;

            HttpModuleCollection mods = ctx.Modules;

            System.Web.SessionState.SessionStateModule ssm = (SessionStateModule)mods.Get("Session");

            System.Reflection.FieldInfo[] fields = ssm.GetType().GetFields(BindingFlags.NonPublic | BindingFlags.Instance);

            SessionStateStoreProviderBase store = null;

            System.Reflection.FieldInfo rqIdField = null, rqLockIdField = null, rqStateNotFoundField = null;

            SessionStateStoreData rqItem = null;

            foreach (System.Reflection.FieldInfo field in fields)

            {

                if (field.Name.Equals("_store")) store = (SessionStateStoreProviderBase)field.GetValue(ssm);

                if (field.Name.Equals("_rqId")) rqIdField = field;

                if (field.Name.Equals("_rqLockId")) rqLockIdField = field;

                if (field.Name.Equals("_rqSessionStateNotFound")) rqStateNotFoundField = field;

                if ((field.Name.Equals("_rqItem")))

                {

                    rqItem = (SessionStateStoreData)field.GetValue(ssm);

                }

            }

            object lockId = rqLockIdField.GetValue(ssm);

            if ((lockId != null) && (oldId != null))

            {

                store.RemoveItem(Context, oldId, lockId, rqItem);

            }

            rqStateNotFoundField.SetValue(ssm, true);

            rqIdField.SetValue(ssm, newId);

        }

Get text from html string c#

using System.Text.RegularExpressions;

string str = Regex.Replace(HttpUtility.HtmlDecode(HTMLString), "<.*?>", string.Empty);

How can I get the number of days between 2 dates in Oracle?

when subtracting two dates in Oracle By default its return number of days.

--Passing one date parameter and subtracting from current date

select TRUNC(sysdate) - to_date('1/3/2017', 'dd/MM/yyyy') AS DiffDate

  from dual;

--Passing both date parameter and subtracting lower date from greater date

SELECT to_date('2017-03-06', 'YYYY-MM-DD') -

       to_date('2017-03-01', 'YYYY-MM-DD') AS DiffDate

  from dual;

--To get the number of days different in SQL statement

SELECT TRUNC(sysdate) -

       to_date(to_char(created, 'dd/MM/yyyy'), 'dd/MM/yyyy') As Datediff

  FROM dba_objects

 WHERE object_name = 'TABLE_NAME'

   AND owner = 'TABLE_OWNER'

   AND object_type = 'TABLE';

Get table creation date in Oracle / SQL

--Oracle

 SELECT Object_Name "Table_Name", created "Create_Date"

    FROM dba_objects

   WHERE object_name = 'TABLE_NAME'

     AND owner = 'TABLE_OWNER'

     AND object_type = 'TABLE';

--SQL

SELECT NAME 'Table_Name', Create_Date,  modify_date

FROM   sys.tables

WHERE  NAME = 'TABLE_NAME'

Get all table name in Oracle / SQL

--Oracle

SELECT * FROM all_tables;

SELECT owner, table_name FROM all_tables;

SELECT owner, table_name FROM all_tables WHERE table_name = TABLE_NAME';

--SQL

SELECT * FROM  sys.tables

SELECT NAME 'table_name' FROM sys.tables

SELECT NAME 'table_name' FROM sys.tables WHERE NAME ='TABLE_NAME'

How to calculate time difference between two dates?

--ORACLE

CREATE OR REPLACE FUNCTION DATETIMEDIFFCALC(FRMDATE DATE, TODATE DATE)

  RETURN VARCHAR2 AS

  V_OUT VARCHAR2(100);

  V_DAY  INTEGER;

  V_HR   INTEGER;

  V_MN   INTEGER;

BEGIN

  SELECT EXTRACT(DAY FROM DIFF),

         EXTRACT(HOUR FROM DIFF),

         EXTRACT(MINUTE FROM DIFF)

    INTO V_DAY, V_HR, V_MN

    FROM (SELECT (CAST(FRMDATE AS TIMESTAMP) - CAST(TODATE AS TIMESTAMP)) DIFF

            FROM DUAL);

  V_OUT := 'DAY : ' || V_DAY || ' HOUR : ' || V_HR || ' MIN : ' || V_MN;

  RETURN V_OUT;

END DATETIMEDIFFCALC;

--SQL

DECLARE @FROM_DATE DATETIME = '2017-03-01 12:12:12:122'

DECLARE @TO_DATE DATETIME = GETDATE()

SELECT CONCAT('DAY :',DATEDIFF(DAY,@FROM_DATE,@TO_DATE), ' HOUR :',DATEDIFF(HH,@FROM_DATE,@TO_DATE), ' MIN :',DATEDIFF(MM,@FROM_DATE,@TO_DATE))

how to get a time part from Date in Oracle?

--12 Hour Format

SELECT TO_CHAR(SYSDATE,'HH12:MI:SS') FROM  DUAL;

--24 Hour Format

SELECT TO_CHAR(SYSDATE,'HH24:MI:SS') FROM  DUAL;

--Hour Format with AM/PM

SELECT TO_CHAR(SYSDATE,'HH12:MI:SS AM') FROM  DUAL;

SELECT TO_CHAR(SYSDATE,'HH24:MI:SS AM') FROM  DUAL;

The AM will indicates that either its morning time or afternoon time automatically.