Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

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,677
    Likes Received:
    131
    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.