FiveTech Support Forums

 ntab:=oodbc:query('select * from ventas limit 0')
  ntab:getblankrow(.f.)
  ntab:caja  := hvnum["caja"]
  ntab:fecha   := date() // aca toma la fecha de la PC, pero quisiera hacer la funcion current_date() de mysql
  ntab:momento := date() +" " +time() // aca me gustaria poner now()
  ntab:cliente   := "A Consumidor Final"
  ntab:save()
  ntab:end()

ntab:=oodbc:query('select * from ventas limit 0')
  oRow := ntab:getblankrow(.f.)
  oRow:caja  := hvnum["caja"]
  oRow:fecha   := oodbc:query("select curdate() as fecha from dual"):fecha
  oRow:momento := oodbc:query("select now() as hora from dual"):hora
  oRow:cliente   := "A Consumidor Final"
  ntab:oRow := oRow 
  ntab:save()
  ntab:end()

CREATE TABLE mitabla (
   momento DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
)

CREATE TABLE mitabla (
   momento DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `modify_dt`  TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)

`createdate` DATE NOT NULL DEFAULT (CURRENT_DATE)

ALTER TABLE `test`.`art524`   
  ADD COLUMN `fecha_alta` DATE  DEFAULT (CURRENT_DATE)  ;
Resultado
Error Code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(CURRENT_DATE)' at line 2

#include "fivewin.ch"

function Main()

   local oCn, oRs

   SET DATE ITALIAN
   SET CENTURY ON

   oCn   := maria_Connect( "209.250.245.152","fwh","fwhuser","FiveTech@2022" )
   oCn:lShowErrors   := .t.
   ? oCn:cServerInfo
   xbrowser ocn:ListTables()

   oCn:DropTable( "dt" )

   ? oCn:CreateTable( "dt", { ;
      { "NAME", "C", 10, 0 }, ;
      { "NUMB", "N", 10, 0 }, ;
      { "CRDT1", "DATE NOT NULL DEFAULT (CURRENT_DATE)", 8, 0 }, ;
      { "CRDT2", "DATE NOT NULL DEFAULT (CURRENT_DATE())", 8, 0 }, ;
      { "CRDTT", "@", 8, 0 }, ;
      { "UPDTT", "=", 8, 0 } } )
      
   FW_MemoEdit( oCn:CreateTableSQL( "dt" ) )

   oRs := oCn:dt
   oRs:Edit()
   xbrowser oRs FASTEDIT

   oCn:Close()

return nil

CREATE TABLE `dt` (
  `id` int NOT NULL AUTO_INCREMENT,
  `NAME` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8_unicode_ci DEFAULT NULL,
  `NUMB` bigint DEFAULT NULL,
  `CRDT1` date NOT NULL DEFAULT (curdate()),
  `CRDT2` date NOT NULL DEFAULT (curdate()),
  `CRDTT` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDTT` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci