Expression-NOW() (insert current date and time into database)(VAD)

Discussion in 'CRM / Helpdesk / App Integration' started by pondsenth, Mar 2, 2017.

Thread Status:
Not open for further replies.
  1. pondsenth

    Joined:
    Nov 4, 2016
    Messages:
    8
    Likes Received:
    1
    #1 pondsenth, Mar 2, 2017
    Last edited: Mar 2, 2017
  2. pondsenth

    Joined:
    Nov 4, 2016
    Messages:
    8
    Likes Received:
    1
    Image
     

    Attached Files:

    • 1.jpg
      1.jpg
      File size:
      29.6 KB
      Views:
      6
  3. edossantos

    edossantos Support Team
    Staff Member 3CX Support

    Joined:
    Jun 27, 2007
    Messages:
    1,058
    Likes Received:
    75
    Hi @pondsenth,

    You should use the SQL command to get the current date. For example in SQL server it's getDate (), but that depends on your SQL engine. That way the database engine determines the current date.

    Kind regards.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.