format daty mySQL

Thread View: pl.comp.lang.vbasic

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Max Fri, 27 Nov 2009 10:36

#104390

Author: Max
Date: Fri, 27 Nov 2009 10:36

6 lines
1150 bytes

Witam! Mam potrzebę konwersji daty windows (np. 27.11.2009 11:30:12) na datę od
1970r. dla bazy mySQL. Czy w VBA mamy gotową funkcję, czy należy to zrobić
ręcznie wg jakiegoś wzoru? Pozdr!

-- 
Wysłano z serwisu OnetNiusy: http://niusy.onet.pl

Re: format daty mySQL

#104391

Author: janusz
Date: Fri, 27 Nov 2009 17:23

12 lines
1270 bytes

Witam

Moze tak

Sub ZmienDate()
Dim MyDate As String
MyDate = "27.11.2009 11:30:12"
MsgBox CDate(Format(Replace(MyDate, ".", "-"), "yyyy/mm/dd;@"))
End Sub


Janusz

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads