hi guys
I am writing some data to my database and i want to sort it by date/time so i need to put a timestamp on my entries.
I have coded this right now
i know that the timestamp is wrong but can someone make it right for me ?Code:str.Format("UPDATE webcapsdeployment SET Build='%s',Date2='%s', Dbweek='%s', Employe='%s', Comments='%s', Timestamp='now()' WHERE Platform = 'SAND'",m_sSandBuild, m_sSandDate, m_sSandDbweek, m_sSandEmploye, m_sSandComments); db.ExecuteSQL(str);